You want to create a new calculated key figure using a Boolean condition, but when you try to save it an error message stating that there was an error while calculating the formula.
Reproducing the Issue
- Go to the Business Analytics work center and access the view Design Key Figures;
- Click in New to create a new key figure;
- In the new screen define a name for the key figure and select a data source, this data source can be any of the SAP Standard Data Sources or a custom data source, created by a user in the system, also change the type of the key figure to Calculated Key Figure, then click in Next;
- In this next screen you will define the calculation that this key figure will be based on.
Usually the error is caused because the formula is not being written with the correct logic, usually we would use, for instance, the formula: "Key Figure"NE(1, 0) which would return the error message for us.
To resolve this issues we must have in mind which Boolean condition that we want to use and which key figure we want to compare. In this case, I will be using the NE (Not Equal) condition.
All of the Boolean conditions will return 1 if the condition is true and 0 if the condition is false, see the example below:
NE("Key Figure", 100)
In the example above the key figure will show 1 if the Key Figure is not 100 and 0 if it is 100.
The same logic has to be applied in other boolean conditions available within the SAP Business ByDesign.
You can refer to the document Create and Edit a Key Figure available in the Help Center inside your ByD system.
KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , How To