Ask Your Question

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.


edit retag flag offensive close merge delete

1 answer

Sort by » oldest newest most voted

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 link more
Login/Signup to Answer

Question Tools


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

Seen: 295 times

Last updated: Mar 06 '13