on 04-18-2005 10:25 PM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
24 | |
11 | |
9 | |
7 | |
5 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.