Skip to Content
0
Former Member
Sep 23, 2010 at 06:25 PM

Condition with signed data

17 Views

Hi,

I need to acomplish the following requeriment, if the value of the account 5324000000 is negative, then I need to post value zero in account 5234000000 and copy the value of the account 5324000000 in the account 521000000.

I try to use this formula in the account dimension, but it doesn't work.

iif(([Account].[5324000000]<0), [Account].[521000000],0)

How can i fix the issue? using mdx?

Thanks in advance.

Regards,

Miguel

How can i fix the issue? using mdx?