Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
So that might work if I'm calculating an average accross rows but what if I'm calculating averages within each column?
In that case maybe you'll need to AGGR() the average expression.
Please attach a mock application with this issue so we can help you further.
Hi.
If it possible with your data model: =Sum(Numerator)/Sum(Denominator)
This usually is a correct way to aggregate on both dimension and total levels.