I am trying to sum all descendants of a specific member based upon a
conditional statement. I am new to this, so I am not 100% sure of the best
means of accomplishing this. Here is what I have so far, but it obviously
doesn't work.

Sum(Descendants(Account_GL.CurrentMember),IIF(Acco unt_GL.CurrentMember.Properties("RATEACCT")<>"", ADB * ADBRATE,SUM()

I ended up changing the statement to look like this and it appears to be
working. Is this the most efficient manner to approach this problem?

IIF(Account_GL.Currentmember.Properties("RATEACCT" )<>"",ADB *
ADBRATE,Sum(Descendants(Account_GL.Currentmember),
IIF(ISLEAF(Account_GL.Currentmember) OR
(Account_GL.Currentmember.Properties("RATEACCT")<> ""), ADB * ADBRATE, 0))),
solveorder = 8

"txksa" wrote: