on 2024 Feb 28 10:52 PM
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.
Request clarification before answering.
User | Count |
---|---|
12 | |
2 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.