cancel
Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

anton_kuznetsov4
Participant
0 Kudos

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.

Answers (3)

Answers (3)

anshu_lilhori
Active Contributor
0 Kudos

Dzmitry,though you have marked this thread as answered but i think you have not got the desired result yet.


To get the correct total i would advice to make use of Exception aggregation.


Choose your formula--Hit the aggregation tab--Exception aggregation as Summation/Total and Reference characteristic as Month.


Hope this helps.


Regards,

AL

former_member199945
Active Contributor
0 Kudos

For new formula change properties calculate result as summation , make sure that in advanced tab of that formula use result of this formula must be selected.

Thanks.

Former Member
0 Kudos

Unfortunately this does not help !

former_member182470
Active Contributor
0 Kudos

What I mean was "Use Result of this Formula" only.

Former Member
0 Kudos

former_member182470
Active Contributor
0 Kudos

Use appropriate setting in Formula collision under Advanced tab of your Formula.

Former Member
0 Kudos

It does not help!