Skip to Content
0
Nov 21, 2012 at 09:42 AM

MDX statement IIF error

32 Views

Hi All,

When i am using the below IIF MDX formula , i am getting error message can you please help by correcting the below.

Error : UJQ_EXCEPTION:MDX Statement error "Invalid MDX command with (....)"

[FLOW].[#F_120]=IIF (([FLOW].[F_130]+[FLOW].[F_410]-[FLOW].[F_100])>0,[FLOW].[F_130]+[FLOW].[F_410]-[FLOW].[F_100],0))

*COMMIT