Hi, Experts,
I have BPC 10.0 NW SP2.
I have two issues to solve... I created another formulas member and they are working well.
A) I try to create a formula member for the account member called FIXEDCOST. I need to sum all account members that the account property [COSTTYPE]= 'CUSTOFIXO'. I try this code, but it is not working.
SUM({[ACCTEXP].CURRENTMEMBER.PROPERTIES("2/CPMB/YLPSI5P")="CUSTOFIXO"},[AUDITTRAIL].[DESP_TOTAL])
May anybody help me? Do I need to use a IIF?
B) I try to create a formula member for the account member called COSTBYTON. We need to do: TOTALCOST / VOLUME. But the VOLUME is not a fixed member. It is a different member from account dimension that is equal to a entity property (called VOLUME) at ENTITY dimension. Each cost center could has a different volume to be used in teh calc. For example:
i) for cost center CC_1 this property at ENTITY dimension has VOLUMEPRODTOTAL. There is a account member called VOLUMEPRODTOTAL. So, in this case, the correct calc is COSTBYTON= TOTALCOST / VOLUMEPRODTOTAL.
ii) for cost center CC_2 this property at ENTITY dimension has VOLUMTRANSTOTAL. There is a account member called VOLUMETRANSTOTAL. So, in this case, the correct calc is COSTBYTON= TOTALCOST / VOLUMETRANSTOTAL.
I've tried some different codes, but they are not working..
Regards,
Ana Teresa