Problems with calculations in Impromptu 6.0

[vorvad]

I'm having a problem with precision in Impromtu 6.0.
I am calculating a column (unit_price * Qty), but it keeps ignoring everything to the right of the decimal. I.E.
(29.95 * 1)gives me 29, not 29.95.
The columns are: unit_price (number 13,5) and qty (13,4)
I can paste the sql ito a query tool, and I get back the correct data. Can anyone give me some ideas as to why this is happening?
Thanks in advance
Trevor B

 

[Brad123]

Have you checked the formatting of the column to ensure that you are displaying the result correctly?

Right click on the column and chose "Format", and you should be able to change the format under the "Data" tab.

Hope this helps!

Brad