How can we calculate the value in Calculated column in each summary row?

[EPM Solutions]

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

[paramvir]

Here is the solution:

https://plnkr.co/edit/PfvH6kfr9uJIqyNc

[EPM Solutions]

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

[paramvir]

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

[EPM Solutions]

Hello Team,

Thank you so much