You are creating a calculated key figure with a number of components, and you need to set brackets in the formula to get the desired result. However, there is no option to set brackets manually; the system sets them automatically and it may not be according to your requirement.
Let us assume the following example requirement - you would like to set up the following formula:
((A - B) / C)+1
(A, B and C stand for key figure names which are used in your formula).
When you enter this formula in the key figure wizard, you get the following result:
A - (B / (C +1))
This will yield a different result.
SAP Business ByDesign
Reproducing the Issue
- Go to the work center Business Analytics and the view Design Key Figures.
- Click New.
- In step 2, enter a key figure name, a data source, and the type Calculated Key Figure.
- Click Next.
- Enter your formula here.
You notice the brackets are set incorrectly and you would like to know how to change this.
You have to enter the major components of the formula first, and then proceed to add smaller and smaller parts of the formula.
This way the brackets will be added as expected.
In this example, enter the following first:
A + 1
Then click into the A component and add the division. The brackets will be added as follows:
(A / C) + 1
Now you just need to add the subtraction by clicking into the A component again. The brackets will be added like this:
((A - B) / C) + 1
key figure, create, business analytics, brackets, parenthesis, parentheses, klammern, formula, calculation , KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , How To