Hi all! My last post on Median calculation went without replies. I hope I will get replies on this one.
I need to implement a seemingly simple % calculation as follows:
% = (Count of categories with [Measure] value = 0 or [Measure] value missing) / (Total count of categories)
Can I do this directly in Report Studio?
Or should I have the numerator and denominator pre-calculated in the cube and simply do the percentage calculation in the report ?
You can do either.
If you want to calculate it in the report, you could use an expression such as
count([Measure] within set filter([your level or set of members], [Measure] = 0 or [Measure] is null)) / count([Measure] within set [your level or set of members])
Cheers!
MF.