3 Replies Latest reply on Sep 17, 2018 12:48 AM by pullarao miriyala

# i am not able to find average of average

Hi All,

I am trying to calculate scorecards which contain columns i have already averaged it on top of the average i want to find out overall average.

example:  ((avg[col1]+avg[col2]+avg[col3])/3 +  (avg[col4]+avg[col5]+avg[col6]+avg[col7]+avg[col8])/5)/2

i am trying to calculate like above what i have given but it is showing null i am not able to find solution can please tell me how to calculate.

• ###### 2. Re: i am not able to find average of average

Pullarao,

Formula seems to be correct , Can you share the worksheet or sample data where you are facing this.

• ###### 3. Re: i am not able to find average of average

example:  ((avg[col1]+avg[col2]+avg[col3])/3 +  (avg[col4]+avg[col5]+avg[col6]+avg[col7]+avg[col8])/5)/2

Above example i want to make it as dynamic means

1. if any condition it won't be fail (eg. some times divisions also comes into the calculation that time if denominator is zero means it won't work)

2. some times new metrics will add to the calculation that time also it won't work bcoz i am directly dividing so we never know when the new metrics  will add.

so i facing these two challenges now can any one help me on this.