Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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 (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.

Tapan

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

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question