Enterprise Resource Planning Blogs by SAP
Get insights and updates about cloud ERP and RISE with SAP, SAP S/4HANA and SAP S/4HANA Cloud, and more enterprise management capabilities with SAP blog posts.
cancel
Showing results for 
Search instead for 
Did you mean: 
former_member240517
Participant
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. ?
9 Comments