Dear SAP Communty,
We are having an issue with the calculation of the member formula: we have created several member formulas on the account dimension that calculate a ratio type (A/B) at the lowest level of the entity dimension. At the Entity Dimension node level, we want to sum all lowest members of the Entity Dimension. In other words, the objective is to have the sum of the ratios of the lowest level but at the parent level.So we use this MDX formula: ETP_SST1 = IIF([NBJO]=0,NULL,IIF([ENTITY].CURRENTMEMBER.PROPERTIES("CALC")="N", ([D12])/IIF([NBJO] = 0,NULL,[NBJO]),SUM(DESCENDANTS([ENTITY].CURRENT MEMBER,20,LEAVES),(([D12])/IIF([NBJO]=0,NULL,[NBJO])))))