Skip to Content
0
Former Member
Jul 06, 2010 at 01:30 PM

MDX Help Needed.

14 Views

Hi

I need some help on MDX. I have the following statement:

WHEN P_ACCT

IS "P00400"

REC (EXPRESSION=(12478 * LOOKUP(S_UIF)),P_ACCT="IKR0000640000")

ENDWHEN

However, I need the an if statement in there, to reflect the following pseudcode:

If P00400 <= 12478.

IKR0000640000" = P00400 * LOOKUP(UIF)

else

IKR0000640000" = 12478 * LOOKUP(UIF)

endif.

How would I do it using MDX?