ParamQuery

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

Title: How can we calculate the value in Calculated column in each summary row?
Post 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

Title: Re: How can we calculate the value in Calculated column in each summary row?
Post by: paramvir on December 16, 2020, 09:14:53 pm
Here is the solution:

https://plnkr.co/edit/PfvH6kfr9uJIqyNc
Title: Re: How can we calculate the value in Calculated column in each summary row?
Post by: EPM Solutions on December 17, 2020, 10:01:36 am
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
Title: Re: How can we calculate the value in Calculated column in each summary row?
Post by: paramvir on December 18, 2020, 11:07:51 am
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
Title: Re: How can we calculate the value in Calculated column in each summary row?
Post by: EPM Solutions on December 21, 2020, 08:32:14 am
Hello Team,

Thank you so much :)