If you're a new user of AppGini, feel free to ask general usage questions, or look for answers here.
-
mohamed
- Veteran Member
- Posts: 88
- Joined: 2020-04-19 16:18
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 ?!
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

- Posts: 327
- Joined: 2013-09-19 10:23
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: 88
- Joined: 2020-04-19 16:18
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