This blog will approach Data Operators for creating new key figures.
If you want to check another available operators, please check the blog posts below:
- Boolean Operators: https://blogs.sap.com/2019/04/12/creating-key-figures-boolean-operators/#
- Mathematical Operators: https://blogs.sap.com/2019/04/17/creating-key-figures-mathematical-operators/
- Trigonometric Operators: https://blogs.sap.com/2019/04/24/creating-key-figures-trigonometric-operators/
Data Operators in your system
I’m going to provide with a practical example on the operators. Please consider the formulas used and change their values as below:
ValueOrKeyFigureToBeCompared1 = Confirmed Quantity
ValueOrKeyFigureToBeCompared2 = Ordered Quantity
After the explanation of each Data Operator, you will find a table with example of possible results based on the provided values and formulas.
It counts the number of values per row.
Is zero if the calculation causes a division by zero. Otherwise, the regular result of the expression will be provided.
Example: NDV0(“ValueOrKeyFigure1”/ “ValueOrKeyFigure2”)
Is zero if the calculation of the mathematical expression leads to an arithmetical error.
Example: NOERR(“ValueOrKeyFigure1”/ “ValueOrKeyFigure2”)
Indicates how high the percentage amount is with regard to the result. Result here means the result of the aggregation at the next-highest level (intermediate result).
Indicates what percentage the amount is of the grand total. Grand total here means the result of the aggregation at the highest level of the list.
Transforms a value into date.
Returns value 1 if the <expression> is 0, otherwise 0
Example: DELTA(“ValueOrKeyFigure1”/ “ValueOrKeyFigure2”)
It removes any unit or currency existent in the key figure value.
Returns the result of the operand to all rows or columns.
Switches the value of a key figure to time.
Table with examples for Data Operators
I hope you all have been able to understand a bit more on Data Operators. If you have any doubt, please do not hesitate on commenting them below. ?