Formula Calculation on Result Row
I have a report where there are three key figures in 3 columns. Column 3 is (value in column a)/(value in column b). That is if a,b,c are values c = a/b. Now my problem is this. In the results row for this column I want the same formula to be applied. That is results row value should be (a1a2a3---an)/(b1b2b3----bn) instaed of the average of column c.
I tried all settings of formula collision and still I am not getting the value I want. Any suggestions please?
I am using SAP BW 3.0 version.
Björn Grahlher replied
I tried myself in BW 3.5... I'm sorry, I gave wrong information - you have to define formula collision as "Result from Competing Formula"! Now it's working fine for me.
Other suggestion is creating a calculated key figure where you specify "After Aggregation" in properties for "Time of Calculation". This is also working fine for me.