### Author Topic: How can we calculate the value in Calculated column in each summary row?  (Read 986 times)

#### EPM Solutions

• Pro Ultimate
• Full Member
• • Posts: 182 ##### How can we calculate the value in Calculated column in each summary row?
« 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

« Last Edit: December 16, 2020, 05:18:47 pm by EPM Solutions »

#### paramvir

• Hero Member
•     • • Posts: 5245 ##### Re: How can we calculate the value in Calculated column in each summary row?
« Reply #1 on: December 16, 2020, 09:14:53 pm »
[ Only Pro members may read this post. ]

#### EPM Solutions

• Pro Ultimate
• Full Member
• • Posts: 182 ##### Re: How can we calculate the value in Calculated column in each summary row?
« Reply #2 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

#### paramvir

• Hero Member
•     • • Posts: 5245 ##### Re: How can we calculate the value in Calculated column in each summary row?
« Reply #3 on: December 18, 2020, 11:07:51 am »
[ Only Pro members may read this post. ]

#### EPM Solutions

• Pro Ultimate
• Full Member
• • Posts: 182 ##### Re: How can we calculate the value in Calculated column in each summary row?
« Reply #4 on: December 21, 2020, 08:32:14 am »
Hello Team,

Thank you so much 