Formula seems to be correct , Can you share the worksheet or sample data where you are facing this.
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.