Forum Discussion
Using Whatif Measures and Average on Measures
I have a dataset as below. Parent Child1 Metrics Val WhatIf Parameter P1 C1 M1 0.7 C1 val1 P1 C1 M2 0.8 C2 val2 P1 C2 M3 0.9 C3 val3 P1 C2 M4 0.6 ...
Column "Val" - It is the value corresponding to the Metrics. This value should be rolled up to valculate the average values for Child ( All Metrics for the child). All the child average will go parent ( group by Rollup Concept)
To the Child averages we want to apply the WhatIF and it should get reflected on Parent.
What's the range of the WhatIf? parameters? Yes Parameter.. % range ( 1 to 100%)