Member Formula to calculate average price
I need some help with member formulas. We are fairly new to BPC and are currently set up on 10.0. We've barely utilized member formulas and I'm hoping to get a little guidance.
In this scenario we're looking to apply a formula to the account dimension taking Revenue/Units. The current set up I have works at the base member level and a roll up level for business unit (after I turned on Calculate Parents in Hierarchy), but if I try to select multiple entities, the calculation returns a sum. Please advise how I can get this to apply for any cross section or if it's better to apply local members for something like this.
Vadim Kalinin replied
It will not work for multiple member selection. And in general multiple member selection has to be avoided due to low performance. Just create additional hierarchy and use parent instead of multiple members.
P.S. For multiple members you can perform calculation of average price using local member having sales and units on the report.