TM1 Forum

Hi All,

I'm translating a system from SAP BPC to TM1, I have to create a formula like:

[VL_0000000_D]= if currentmember = DB('APS_PnL',!APS_Entity,'VL_0000000',!APS_RPTCurrency,!APS_DataSrc,!APS_Scenario,!APS_Time,!APS_Account_PnL),
DB('APS_PnL',!APS_Entity,!APS_Product_PnL,!APS_RPTCurrency,!APS_DataSrc,!APS_Scenario,!APS_Time,'VL_0000000'),
DB('APS_PnL',!APS_Entity,!APS_Product_PnL,!APS_RPTCurrency,!APS_DataSrc,!APS_Scenario,!APS_Time,ELPAR(PnL,'VL_0000000',1)

the fact is I honestly don't know how to specify the current member condition.
is there a way to specify it?

Thanks in advance.

Hi,

I'm not sure what you're expecting here, but if you're specifying a rule for the element ['VL_0000000_D'] (don't forget the single quotes), the rule will only be calcultated when the element 'VL_0000000_D' is included in the selected area... So if element 'VL_0000000' is in the same dimension as 'VL_0000000_D', the condition in the rule is useless, because the rule will never fire for element 'VL_0000000'.
In general, you can use !dimname @= 'SomeElement' to check whether the current member in a dimension 'dimname' matches the element 'SomeElement'.

Michel