Skip to Content
0
Jan 27, 2011 at 09:54 PM

account formual error - Invalid MDX command

20 Views

The following account formula works fineu2026

IIF([ACCOUNT].[WA_DILUTED_SHARES]=0,0,[ACCOUNT].[PL_NET_INC]/[ACCOUNT].[WA_DILUTED_SHARES]); SOLVE_ORDER = 100

Would like to use account WA_DIL_SHARES_Y instead of account WA_DILUTED_SHARES when the period is year total, so change the formula as follows, but receiving error message

IIF([TIME].CURRENTMEMBER.PROPERTIES("LEVEL")="YEAR",IIF[ACCOUNT].[WA_DIL_SHARES_Y]=0,0,[ACCOUNT].[PL_NET_INC]/[ACCOUNT].[WA_DIL_SHARES_Y]),IIF([ACCOUNT].[WA_DILUTED_SHARES]=0,0,[ACCOUNT].[PL_NET_INC]/[ACCOUNT].[WA_DILUTED_SHARES]); SOLVE_ORDER = 100

Would appreciate any help to resolove this....