I need some help on MDX. I have the following statement:
REC (EXPRESSION=(12478 * LOOKUP(S_UIF)),P_ACCT="IKR0000640000")
However, I need the an if statement in there, to reflect the following pseudcode:
If P00400 <= 12478.
IKR0000640000" = P00400 * LOOKUP(UIF)
IKR0000640000" = 12478 * LOOKUP(UIF)
How would I do it using MDX?