Hi
When I am using the following statement in MDX , It is raising more than million records and causing report refresh issue.
IIF(([ACCOUNT_S].[T2_REVENUE]<=0),0,([ACCOUNT_S].[T2_REVENUE]-[ACCOUNT_S].[T2_COS_STD])/[ACCOUNT_S].[T2_REVENUE]).
Here my requirement is to place zero when revenue is less than zero.
Can you provide us any other solution.
When I replaced 0 with NULL, it is working fine.
IIF(([ACCOUNT_S].[T2_REVENUE]<=0),NULL,([ACCOUNT_S].[T2_REVENUE]-[ACCOUNT_S].[T2_COS_STD])/[ACCOUNT_S].[T2_REVENUE])
regards
Mahesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.