Skip to Content
0
Former Member
Nov 19, 2012 at 09:43 PM

Member Formula Sintaxe

32 Views

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