EPCM - Applying percentage to an amount using dimension member hierarchy
In EPCM, can we apply a percentage to member value using dimension consolidation operation?
Scenario : Non-allocable amount of a cost needs to be calculated. We have total cost and non allocable percentage in 2 account dimension member. Can we create a hierarchy like below and find the non allocable amount without using calculation rule? Goal is to reduce number of custom calculation rules/member formula.
Please find below sample calculations and configuration setup. But result is not as expected. Any ide what could be the reason? Please do let me know in case of any further details are required.