Hi,
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:
Data Operators in your system
- COUNT
- NDIV0
- NOERR
- %CT
- %GT
- DATE
- DELTA
- NODIM
- SUMCT
- SUMGT
- TIME
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.
COUNT
It counts the number of values per row.
Example: COUNT(“ValueOrKeyFigure1”)
NDIV0
Is zero if the calculation causes a division by zero. Otherwise, the regular result of the expression will be provided.
Example: NDV0(“ValueOrKeyFigure1”/ “ValueOrKeyFigure2”)
NOERR
Is zero if the calculation of the mathematical expression leads to an arithmetical error.
Example: NOERR(“ValueOrKeyFigure1”/ “ValueOrKeyFigure2”)
%CT
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).
Example: %CT(“ValueOrKeyFigure1”)
%GT
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.
Example: %GT(“ValueOrKeyFigure1”)
DATE
Transforms a value into date.
DELTA
Returns value 1 if the <expression> is 0, otherwise 0
Example: DELTA(“ValueOrKeyFigure1”/ “ValueOrKeyFigure2”)
NODIM
It removes any unit or currency existent in the key figure value.
SUMCT
Returns the result of the operand to all rows or columns.
Example: %SUMCT(“ValueOrKeyFigure1”)
SUMGT
Example: %SUMGT(“ValueOrKeyFigure1”)
TIME
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. ?