Hi all,

I believe this is a fairly easy question. I am trying to do a relative percent of parent calculation. The math works, except for at the all level where I would like the value to be 1 (or 100%). I've tried testing for item(0) on the currentmember but that didn't work. Any help would be appreciated. Below is the current MDX statement. Thanks in advance,

Mark

IIF(([Measures].[Current Balance],[Cltv Tier].currentmember.parent) = 0,NULL,[Measures].[Current Balance]/([Measures].[Current Balance],[Cltv Tier].currentmember.parent))

Something like this:

IIF( MyDim.CurrentMember IS MyDim.DefaultMember,
NULL,
<formula here> )

(Might you be the Mark Frank with whom I'm acquainted?)

public @ the domain below
www.tomchester.net

"Mark Frank" <mark.a.frank (AT) wellsfargo (DOT) com> wrote

where I would like the value to be 1 (or 100%). I've tried testing for
item(0) on the currentmember but that didn't work. Any help would be
appreciated. Below is the current MDX statement. Thanks in advance,
Tier].currentmember.parent))