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
0
Comments
Niels Thomsen is what I'm asking here one of the things you just mentioned in today's TARGIT webinar?
Yes it is - this is part of the theme "Calculation Package" - we will update as we get closer to a final decision on roadmap 2025
br/Niels
Please sign in to leave a comment.