Data Functions 
Data Functions
Use
Functions that you can use as operators for defining a calculated key figure.
Features
Value = 1 if operand <> 0, otherwise 0 (numerator)
COUNT(<Expression>)
Delivers the value 1 if the <Expression> is <> 0, otherwise 0.
Processing a Value as a Date
DATE
The value is seen as the number of days from 00.00.0000 onwards and output as a date.
The value can be between 0 and a million, which gives a date between 01.01.0000 and 27.11.2738.
Value = 1 if operand = 0, otherwise 0
DELTA(<Expression>)
Delivers the value 1 if the <Expression> is 0, otherwise 1.
The function is identical to the NOT operator and should no longer be used.
NDIVO (x): Equals 0 when divided by 0, otherwise x
NDIV(<Expression>)
Is 0 if the calculation of <Expression> causes a division by 0. Otherwise, the result is the value of the expression. It is used to avoid error messages or so that you can continue to calculate a defined result.
Values without Dimensions (without Units)
NODIM(<Expression>)
Delivers purely numerical values of <Expression> and suppresses units and currencies.
Using this function, you can avoid the "mixed currency" character. See SAP Reference IMG ® Business Information Warehouse ® Reporting-relevant Settings ® General Reporting Settings ® Display of Numerical Values in the Business Explorer.
NOERR (x): Equals 0 for undefined calculations, otherwise x
NOERR (<Expression>)
Is 0 if the calculation of <Expression> leads to an arithmetical error. Otherwise, the result is the value of the expression. It is used to avoid error messages or so that you can continue to calculate a defined result.
NOERR(SQRT(-1)) = 0
Result
SUMCT <Operand>
Delivers the result of the operands to all rows or columns (see also Percentage Functions %CT).
|
Year |
Region |
Sales |
SUMCT "Sales" |
|
1999 |
North |
30 |
60 |
|
South |
30 |
60 |
|
|
Result for 1999 |
60 |
180 |
|
|
2000 |
North |
60 |
120 |
|
South |
60 |
120 |
|
|
Result for 2000 |
120 |
180 |
|
|
Overall Result |
180 |
180 |
Overall Result
SUMGT <Operand>
Delivers the overall results of the operands (see also Percentage Functions %GT).
|
Year |
Region |
Sales |
SUMGT "Sales" |
|
1999 |
North |
30 |
180 |
|
South |
30 |
180 |
|
|
Result for 1999 |
60 |
180 |
|
|
2000 |
North |
60 |
180 |
|
South |
60 |
180 |
|
|
Result for 2000 |
120 |
180 |
|
|
Overall Result |
180 |
180 |
Query Result
SUMRT <Operand>
Delivers the query result of the operand. For more information about the difference between the overall result and the query result, see Percentage Functions ® %GT and %RT.
Processing a Value as a Time
TIME
The time is seen as seconds from 00:00 and output in hours, minutes and seconds. A number is seen as the number of seconds from 00:00 onwards.
A negative number is calculated backwards from 00:00.