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

EPM Solutions

  • Pro Ultimate
  • Full Member
  • *
  • Posts: 182
    • View Profile
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

  • Administrator
  • Hero Member
  • *****
  • Posts: 6113
    • View Profile

EPM Solutions

  • Pro Ultimate
  • Full Member
  • *
  • Posts: 182
    • View Profile
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

  • Administrator
  • Hero Member
  • *****
  • Posts: 6113
    • View Profile
Re: How can we calculate the value in Calculated column in each summary row?
« Reply #3 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

EPM Solutions

  • Pro Ultimate
  • Full Member
  • *
  • Posts: 182
    • View Profile
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 :)