# Formula Calculation on Result Row

Hi

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 (a1*a2*a3*---an)/(b1*b2*b3*----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.

Tapan

##### Björn Grahlher replied

Hi Tapan,

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.

Best regards,

Björn