Skip to Content

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

How to get results row as summation in Formula on Structure in BEx query ?

Hello Bex Experts,
I have created a Formula:(FACT<>0)*FACT+(FACT==0)*PLAN
in Columns in Structure.
The yellow line is  calculate result by this Formula = 51 879 466.

How to do calculate as summation = 101 014 274 kg ?

Thank you for your help,
Dzmitry

Former Member
replied

Try to create calculated key figure and use Exception aggregation by Month as suggested above.

Also you have to unset "Calculation after aggregation" option.

Don't mind if you have only one Rel. Characteristic instead of five , this option appeared only in SP06 patch 1 SP for SAP Bex.

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question