AppGini Community Forums

Hello,

I have set the Calculated Filed to the following SELECT command, whick works perfectly with each row, but the 'grand total' or the Caluclated Sum generated by selecting Show Column Sum does not show the 2 decimlas !!


SELECT ( COALESCE(Access_Charges, 0) + COALESCE(Port_Charges, 0) + COALESCE(MARWAN_Charges, 0) )
FROM MPLS_CLOUD
WHERE MPLS_CLOUD.id = '%ID%'


---
Total Column:
Data Type: Decimal
Length: 10
Precision: 2


Any clue ?!

Thank you ..

Do you have decimal value in at least one of the rows (for example: 565,45)?
If not, sum will appear without decimals. (that is all your numbers are integers).

I ran into this last week, and that is how it works

Have a nice day

AhmedBR,

All values are decimals.
and
I noticed when I do a refresh the total appears with 2 decimlas for a second, then it disappears for some reason.

Thank you ...