Forum Discussion
Allexcept issues in a herarchy
Hello to everyone, hoping you're doing great. Have you ever had an issue with Allexcept ? Let me explain my problem:
In this table, being specific the column "$ Var to Program Avg", I'm using and ALLEXCEPT to get the avg of the values by program in "Unit Calculation" (row 4 equal to 5.36) less (-) Avg Calculation = $ Var to program Avg (5.48 - 5.36 = 0.11). This calculation is good, the issue is that at the program level ("10.00-IN Foxtail Fern"), the value is equal to 0.00 when I whould like to have the sum of the variance at the program level in $ Var to program Avg to sort it and know which one should we look first (There are too many programs).
This is an example:
This is the $ Var to program Avg:
Hi Anonymous,
It seems like a common measure multiple aggregation calculate issue, you can take a look at the following blog to know how to handle this scenario:
Measure Totals, The Final Word
Regards,
Xiaoxin Sheng
1 Reply
Hi Anonymous,
It seems like a common measure multiple aggregation calculate issue, you can take a look at the following blog to know how to handle this scenario:
Measure Totals, The Final Word
Regards,
Xiaoxin Sheng