Data Functions 
Use
These are functions that you can use as operators for defining a formula or 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.01.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.
NDIV0 (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 for 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 operator takes any key figure or (partial) formula in general and makes a TIME type key figure. Go to the formula editor and, for the operator, double-click the data function Process Value as Time and, for the operand, double-click the key figure you want. For example, the formula is then Time (Sales).
The system cuts off the decimal places, interprets the value as seconds, and displays the value in the form +-hh:mm:ss. For example, -4812 is displayed as –1:20:12.
Any time is seen as seconds from 00:00:00 and output in hours, minutes and seconds. A TIME type key figure with value 0 is displayed as 00:00:00.
Negative times are permitted: With a negative time the system calculates from 00:00:00 backwards.
The number of hours can be any amount. After 24 hours the system restarts at 0.
This function is designed for offset calculations, among other things. For example, if you need to deduct four hours with time key figures, then you can set the TIME operator.