English
Ask Your Question
0

Database Query

asked 2012-07-12 13:40:05 +0200

aburrow gravatar image

updated 2013-01-28 23:14:41 +0200

qubit gravatar image

I'm trying to setup a query that displays MemberID and Total Payments in two columns.

That part I've done quite easily. What I need to do is display the Total Payments column in dollar format. The field is stored in the table as "Double", my SQL Statement currently is " SELECT "MemberID", SUM( "PaymentAmount" ) AS "Total Payments" FROM "Payments" GROUP BY "MemberID" ORDER BY "MemberID" ASC "

I've done some more testing. If I remove the "SUM" syntax and just show the "Payments" field it displays in currency format. It appears that something in the "SUM" command is stripping out the currency format.

Thanks

edit retag flag offensive close delete

1 answer

Sort by » oldest newest most voted
0

answered 2013-03-06 10:40:18 +0200

qubit gravatar image

Hi @aburrow,

Do you think that there's something wrong with what SUM() is returning to you?

Please try installing the latest release of LO and see if that shows the same problem.

edit flag offensive delete publish link more
Login/Signup to Answer

Stats

Asked: 2012-07-12 13:40:05 +0200

Seen: 228 times

Last updated: Mar 06 '13