4 Replies Latest reply: Oct 24, 2012 3:12 PM by whiteline _

# Total Mode: Expression Total - How to get accurate average

I have a Chart of calculated averages. I wanted to have a Total Row at the bottom and I'm not sure what 'Expression Total' is calculating but it isn't what I need. Since each calculated value uses a different denominator I need to sum the numerators and divide that by the sum of denominators. Merely Averaging the averages will not work. Am I only able to accomplish this by creating my own Total Row with some complicated expressions? If so how do you reference values from other parts of the Chart.

• ###### Re: Total Mode: Expression Total - How to get accurate average

I guess you may find useful the DIMENSIONALITY() function.

Add it as a expression to see the relationship between cells. The total cells have a zero dimensionality value, so you can then ask IF(DIMENSIONALITY()=0, ...) and set your own total expression.

Hope this helps.

• ###### Re: Total Mode: Expression Total - How to get accurate average

So that might work if I'm calculating an average accross rows but what if I'm calculating averages within each column?

• ###### Re: Total Mode: Expression Total - How to get accurate average

In that case maybe you'll need to AGGR() the average expression.