ParamQuery
General Category => Help for ParamQuery Pro => Topic started by: EPM Solutions on December 16, 2020, 05:16:44 pm

Hello Team,
We want calculate and show result of division by below formula in new column "Calculated" in paramquery grid.
Formula
Calculated = Original Budget/Projected Budget
We added a code snipped in below URL Please check it and update it with a solution.
Plunkr/problem url:
https://plnkr.co/edit/kliEiaTSSrSAk55a

Here is the solution:
https://plnkr.co/edit/PfvH6kfr9uJIqyNc

Hello Team,
Thanks,
But we need to calculate division in each summary row or each row (or every summary row).
0 is showing summary row but we require like 32000/1000=3.2 as shown in below image and plunkr
Please check and give a solution
Plunkr
https://plnkr.co/edit/kliEiaTSSrSAk55a

formulas are computed before grouping of rows, hence they don't work in summary rows.
I've used column.render to fulfil your requirement:
https://plnkr.co/edit/vHRTzvFQ327R8zHx

Hello Team,
Thank you so much :)