Hello Friends. Please help to solve this. I want to put in universe 2 restricted measure
1. AMT TO BE MULTIPLIED BY 100 IF PRICE LIST KEY IS "JY"
I wrote the below MDX but it failed when i run the report . please correct my code
<EXPRESSION>
IIf( [0PRICE_LIST].[LEVEL01].[[20PRICE_LIST]].[Value] = [0PRICE_LIST].[LEVEL01].[[20PRICE_LIST]].[JY] , [Measures].[ZNKF_ZRTAMTTC_L1] * 100,[Measures].[ZNKF_ZRTAMTTC_L1] ))
</EXPRESSION>
I also tried the below it does not work again
<EXPRESSION>
IIf( [0PRICE_LIST].CurrentMember.Name = [0PRICE_LIST].[JY].Name , [Measures].[ZNKF_ZRTAMTTC_L1] * 100,[Measures].[ZNKF_ZRTAMTTC_L1] ))
</EXPRESSION>
2. I also want to do the variable at universe for characteristic
like if price list type is jy or us then allocation territory
but code does not work
<EXPRESSION>
IIf( [0PRICE_LIST].CurrentMember.Name = [0PRICE_LIST].[JY].Name OR [0PRICE_LIST].CurrentMember.Name = [0PRICE_LIST].[US].Name , [ALLOC_TERR], NULL))
</EXPRESSION>
Please help with the above
Thanks
Soniya