Hello,
When I select Show Column Sum of a filed, the following code is generated in the related PHP file !!!!_View.php
$x->HTML = str_replace('<!-- tv data above -->', $sumRow, $x->HTML);
For instance the total is 1450
I am wondering,
1. How to add the currency symbol to it ? e.g., $ 1450
2. How to format the Total Number with; 1000 comma separator ? e.g., 1,450
3. How to format the Total number with; 2 Decimal points ? e.g., 1,450.00
How to Currency Symbol and Change Format of the SUM Number?
How to Currency Symbol and Change Format of the SUM Number?
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: How to Currency Symbol and Change Format of the SUM Number?
Hi,
you could change that line to
$x->HTML = str_replace('<!-- tv data above -->', '$ '.number_format($sumRow, 2, '.', ','), $x->HTML);
you could change that line to
$x->HTML = str_replace('<!-- tv data above -->', '$ '.number_format($sumRow, 2, '.', ','), $x->HTML);
Any help offered comes with the best of intentions. Use it at your own risk. In any case, please make a backup of your existing environment before applying any changes.
Re: How to Currency Symbol and Change Format of the SUM Number?
Hi pböttcher,
Thank you
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