Hi all,

I am trying to replicate my Essbase environment in AS (as
I would like to migrate there).

Using the Calculated cell feature I am trying to build
logic akin to the following.

Fix(Seconds)
IF(@ISMBR("Units") Lines + Loans - dummy loan
ELSE
Lines + Loans
ENDIF
End Fix

This translates into the following: From my product
dimension if the current member is Seconds, then from my
measure dimension take only the units measure and back out
the dummy loan product, otherwise sum the lines and the
loans (Lines and Loans are the only children of Seconds)

Thanks in advance for any help!

Mark