Skip to Content
0
Sep 01, 2020 at 03:47 PM

BPC 11 custom measure

154 Views

Hi experts,

I need to create a custom measure in order to reverse sign of account based on the value of a dimension, in order to do so i created a property named "SIGN" in my dimension with value 0 or 1.

This is my custom measure's code

'IIF([%C_CODE%].CURRENTMEMBER.PROPERTIES("SIGN")="1",-[MEASURES].[/CPMB/SDATA], IIF([%C_CODE%].CURRENTMEMBER.PROPERTIES("SIGN")="0",[MEASURES].[/CPMB/SDATA]),[MEASURES].[/CPMB/SDATA])))';

But it's not working, it gives me an MDX: internal error

I think that my code is not correct

Do you guys have an idea what it might be ?

Thank you