Hello,
I have an Account member formula as below:
IIF([RPTCURRENCY].CURRENTMEMBER.PROPERTIES("CN_TYPE") = "Y", [ACCOUNT1] + [ACCOUNT2], [ACCOUNT1] - [ACCOUNT2]
this is working fine, however, I have a requirement to include a condition to this formula, which is,
to restrict the calculation only to the base members of Entity dimension hierarchy Total node i.e, TOTAL_ENTITY
meaning, I have an Entity sitting outside the Entity hierarchy TOTAL_ENTITY and that should be excluded from the calculation.
as this is a member formula, it runs on wide open data, unless we restrict it.
appreciate inputs.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.