In our grid implementation, a column has a simple formula “ron[=c8/c9]”.
I am using
grid.setMathRound(2);
to round of the values to 2 decimal points.
Also, we have grouping & grand total in footer.
The group header data & the footer total is calculated based on the round of values.
I want the totals to be calculated based on the actual values but not based on the rounded of values.
I am using #stat_total for group header data & footer data for summations.
grid.groupBy(0, ["","","#title","","","","","","#stat_total","","#stat_total"]);
grid.attachFooter([" "," ",“Grand Total”,"#cspan","#cspan","#cspan","#cspan","#cspan","#stat_total"," ","#stat_total"],[]);
So, the summation should be based on actual values & final summation value should be displayed with only 2decimal points.
Any help is highly appreciated.