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 ..
SUM Generated by "Show Column Sum" Does Not Show Decimilas!
SUM Generated by "Show Column Sum" Does Not Show Decimilas!
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
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
Re: SUM Generated by "Show Column Sum" Does Not Show Decimilas!
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
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
Re: SUM Generated by "Show Column Sum" Does Not Show Decimilas!
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 ...
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
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