Average Rollup should not count the parent in the denominator

Koun Han

• July 02, 2020 17:42

Currently, Support says that Roll-up feature includes Parent's attribute/metric in calculating Sum or Average.  This doesn't really make sense when Parent's attribute is empty and you want to use Children's metrics.  

For example, let's say that Parent has the following children:

Child A 10

Child B 6

Child C 5

I expect the Sum roll-up to be 21 and Average roll-up to be 7.   However, currently, it divides 21 by 4 (including the parent itself), which is not correct.  

I can see an instance where the parent itself has a value of its own, and you might want to include that in the roll-up, but at least we should be given an option to exclude parent in the calculation :/

1

• Official comment

  

  Amit Bluman

  • October 07, 2020 16:17

  I wanted to update that this enhancement is coming soon.
  So if the parent has no value it will not be counted in the average rollup. 

  Stay tuned...

  Comment actions Permalink
• 

  Amit Bluman

  • July 09, 2020 12:46
  • Edited

  Thanks, this is an important point.
  The logic of the scenario when the parent has its own value is aligned, I think we should treat the scenario where the parent has no contribution to the value and not include it in the denominator by adding specific settings to treat it. 

  0

  Comment actions Permalink
• 

  Robert Nilsson

  • September 28, 2021 19:25

  What ever happened to this capability?  It's not possible to have "no value" at a parent for calculated fields, so that logic is not helpful.  Was this ever added as a setting?  I can't find it, and you make it sound like it was near term a year ago.

  0

  Comment actions Permalink

Please sign in to leave a comment.