-
1. Re: How to force overall average rather than sum of group averages?
Tram Trinh Sep 4, 2012 5:10 PM (in response to Ratna Sarkar)1 of 1 people found this helpfulHi Ratna,
After the pane got greyed out, did you try dragging the [Av Salary] with the new calculation over to replace the previous one already on the shelf?
It's possible that you still had the previous pill with an AVG aggregation on it, so when you modified the calculation to add the SUM aggregations within it, it was no longer valid in the pane. Usually just replacing the pill with the updated calculated field fixes this. (When you replace it, the pill will then have the AGG() function around the measure, rather than AVG()).
Regards,
Tram.
-
2. Re: How to force overall average rather than sum of group averages?
Ratna Sarkar Sep 6, 2012 8:41 PM (in response to Tram Trinh)Hi Tram
Thanks for your reply. Replacing the pill was not _exactly_ the answer, but, it got me thinking that perhaps I was asking the table to display something undisplayable -- and indeed that was the case. I had gender as one of my variables, and once I forced my calculated average to be an overall sum, it could not be displayed in a table which had different rows for males and females. Removing gender from the table fixed the problem!
Thanks and I hope this helps someone else.
Ratna