cancel
Showing results for 
Search instead for 
Did you mean: 

Substraction in layout

Former Member
0 Kudos

HI

Can any please let me know whether we can do subtractions in third step of layout design like we do additions. If not, what is the best way to do subtractions in the layout.

Thanks,

Raj.

Accepted Solutions (0)

Answers (1)

Answers (1)

gerd_schoeffl
Advisor
Advisor
0 Kudos

Hello Raj,

In the third screen of the layout builder it is only possible to define sums of values (the reason: with BW3.5 we have this Excel frontend feature where the totals are calculated on the fly and where you also can enter the totals and the values are distributed automatically. If we allow substractions etc then this automatic distribution cannot be done).

You have 2 options to calculate such formulas:

1. Use Excel formulas (or macros) provided that you are using Excel in the GUI or the Excel layouts in the Web interfaces

2. define an additional key figure that holds the result of the calculation. Create a planning function that does the calculation.

(or... Use a BW report to show the results of your calculations)

Best regards,

Gerd Schoeffl

SAPNetWeaver RIG BI EMEA

Former Member
0 Kudos

Hi Gerd,

Thanks a lot for your replay and do you have macro which will provide substraction in the excel. The issue here is that rows in the layout are dynamic so I think macro should be able to do the job.

Thanks a lot again.

Raj.