Hierarchy incorrect aggregation

[former_member229754]

Hello Experts,

I've got a classical problem.

Whenever I input the price and Qty and Price from base level it is corresponding wrong calculation on Parent Level.

A formula Sales = Price * Qty is created from EPMFormatting using something like: =$Price *INDIRECT(ADDRESS(ROW(),COLUMN()-1))

I believe the calculation "make sense", but how can I make as expect ?

Dank

[Former Member · Accepted solution]

Hi Pheno,

              As you mentioned above your formula is working fine due to access override you are getting wrong result. As per your example you returned formula for sales in formatting sheet as

   Assume:- In formatting sheet under "Dimension member/formatting" you mentioned

                     Sales = (Content==Sum(price*Qty))

And you had mentioned column as priority.

So what the system will do when there is conflict between ROW & COLUMN as you mentioned column as priority in formatting sheet it will override row formula with column formula.

      In this case if you want to achieve the result then you have to mention "ROW as priority" under "Dimension Member/Formatting" & add your member in the row mention your row formula.

Example: Product =  (Content==Sum(Product1,Product2))

For more information see the screens below.....

Regards,

Aravind.

[former_member186338]

Please, read my document:

Vadim