Custom calculation for a particular member
I have a crosstab with one dimension, one measure, and several rows (members).
The code below works. The "Special Bus Unit" member has their measure multiplied by two factors and all other members just by one factor.
This potential issue with this is: if another member happens to have the same exact measure value as the Special Bus Unit.
Is there a better way to say, IF the business unit is = "Special Bus Unit" THEN [do this math], ELSE [do this other math]?
if sum(0, 0, m1) = sum(0, @@"[Business Unit].[Bus Unit].&[Special Bus Unit]"(l(1)), m1)
then sum(0, 0, m1) * 0.078 * 0.225
else sum(0, 0, m1) * 0.225
Comments
2 comments