Skip to Content
0
Former Member
Apr 11, 2014 at 06:04 PM

Formula Member Error

29 Views

Hi, All,

We are creating a formula member and, when we saw it at Excel it is not working well. The leaf members are correct, but aggregate members have NULL.

The syntax is:

IIF(ISLEAF([TIME].CURRENTMEMBER), [ACCT].[SALDOINICIAL], IIF ([TIME].CURRENTMEMBER.PROPERTIES("/CPMB/L3PWIG6")=NULL,NULL,([ACCT].[SALDOINICIAL],[TIME].CURRENTMEMBER.PROPERTIES("/CPMB/L3PWIG6"))))

The property /CPMB/L3PWIG6 has a time member name or NULL.

We simplified it (only to test) and it still not working:

IIF(ISLEAF([TIME].CURRENTMEMBER), [ACCT].[SALDOINICIAL], IIF ([TIME].CURRENTMEMBER.PROPERTIES("/CPMB/L3PWIG6")=NULL,([ACCT].[SALDOINICIAL],[TIME].[2014.0203]),([ACCT].[SALDOINICIAL],[TIME].[2014.0204])))

In this second syntax, the second IIF seems doesn't work, because at a member that is not NULL (ex: 2014.02 that has 204.0103 in the property /CPMB/L3PWIG6) it shows the first statement ([ACCT].[SALDOINICIAL],[TIME].[2014.0203]) not the second which is the correct one.

Would anybody help us?

Best Regards,

Ana Teresa