Forum Discussion
Error in table totalling Averages
Hi,
I am having an issue with the total of averages in my table reporting the incorrect amount, for example, I have:
| Region 1 | Region 2 | Total |
| 127.76 | 266.93 | 144.85 |
There are other regions that have not provided figures (so are blank), but I wondered how the totalling was working to generate this number (144.85), and if there was a way to fix it?
Thanks!
it computed the average across your entire (well, selected) data. If that's not what you want then you need to define what formula you want (sum of averages sounds wrong too) and then implement that logic on the Totals level of your measure.
2 Replies
it computed the average across your entire (well, selected) data. If that's not what you want then you need to define what formula you want (sum of averages sounds wrong too) and then implement that logic on the Totals level of your measure.