AppGini Community Forums

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

Hi,
you could change that line to


$x->HTML = str_replace('<!-- tv data above -->', '$ '.number_format($sumRow, 2, '.', ','), $x->HTML);

Hi pböttcher,

Thank you