SUM Generated by "Show Column Sum" Does Not Show Decimilas!

If you're a new user of AppGini, feel free to ask general usage questions, or look for answers here.
Post Reply
mohamed
Veteran Member
Posts: 80
Joined: 2020-04-19 16:18

SUM Generated by "Show Column Sum" Does Not Show Decimilas!

Post by mohamed » 2022-07-18 12:05

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 ?! 8-)

Thank you ..
THANK YOU...
AppGini Pro 24.11 -
Calendar - Search Page Maker - Summary Reports - Mass Update - DataTalk -
bizzworxx AppGini Helper JabaScript Library - bizzworxx Inline Detail-View - bizzworxx Helper Pack - AppGini Helper Packaging Tool -
Udemy course

AhmedBR
AppGini Super Hero
AppGini Super Hero
Posts: 327
Joined: 2013-09-19 10:23

Re: SUM Generated by "Show Column Sum" Does Not Show Decimilas!

Post by AhmedBR » 2022-07-18 12:09

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
AppGini 22.14 - xampp 3.3.0 - PHP 7.4.30 - Summary reports - Calendar - Mass update - Messages - AppGiniHelper

mohamed
Veteran Member
Posts: 80
Joined: 2020-04-19 16:18

Re: SUM Generated by "Show Column Sum" Does Not Show Decimilas!

Post by mohamed » 2022-07-18 13:55

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 ...
THANK YOU...
AppGini Pro 24.11 -
Calendar - Search Page Maker - Summary Reports - Mass Update - DataTalk -
bizzworxx AppGini Helper JabaScript Library - bizzworxx Inline Detail-View - bizzworxx Helper Pack - AppGini Helper Packaging Tool -
Udemy course

Post Reply