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,
Anton Kuznetsov 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.