You can use the following data functions when defining a formula or a calculated key figure as an operator.
Operator |
Operator Name |
Description |
---|---|---|
COUNT |
Counter |
COUNT(<Expression>) Returns value 1 if the expression <> identified by <Expression> results in 0, otherwise 0. |
DATE |
Casting Operator Date |
DATE The value is given as the number of days starting from 01.01.0000 and then displayed as a date. The value can be between 0 and a million which allows for a date range between 01.01.0000 and 27.11.2738. |
DELTA |
Delta |
DELTA(<Expression>) Returns value 1 if the expression identified by <Expression> results in 0, otherwise 0. Caution
The function is identical to the operator NOT and should no longer be used. |
NDIV0 |
No DIV0 |
NDIV(<Expression>) Results in 0 if the expression identified by <Expression> is caused by a division by 0 during calculation. Otherwise the result is the value of the expression. This is used to avoid displaying an error message or to be able to calculate further with a defined result. |
NODIM |
Value without Units or Currencies |
NODIM(<Expression>) Returns the pure number value of <Expression> and suppresses the unit and currency. |
NOERR |
No Error |
NOERR(<Expression>) Results in 0 if the expression identified by <Expression> causes a calculation error during evaluation. Otherwise the result is the value of the expression. This is used to avoid displaying an error message or to be able to calculate further with a defined result. |
SUMCT |
Norming Operation Result |
SUMCT <Operand> Returns the result of the operand on the next-highest level (intermediate result) (see also Percentage Functions, %CT). |
SUMGT |
Norming Operation Grand Total |
SUMGT <Operand> Returns the grand total of the operand (see also Percentage Functions, %GT). |
SUMRT |
Norming Operation Query Result |
SUMRT <Operand> Returns the query result of the operand (see also Percentage Functions, %RT). In contrast to the calculation of the grand total, the dynamic filters are not included in the calculation of the query result, that is, it is always normalized to the same size, irrespective of the dynamic filter and navigation status. |
TIME |
Casting Operator Time |
TIME The TIME operator makes a key figure of type TIME of any key figure or general (part) formula. The system removes the decimal places, interprets the value as seconds, and returns the value in the form +-hh:mm:ss. Example
In this way -4812 is displayed as -1:20:12. A number is seend as the number of seconds from 00:00:00 and is expressed in hours, minutes, and seconds. A key figure of type TIME with the value 0 is displayed as 00:00:00. Negative times are allowed: For a negative number the system calculates backwards from 00:00:00. The number of hours can be as high as required. The system starts from 0 again after 24 hours. |
NOERR (x): Equal to 0 for undefined calculations, otherwise x
NOERR(SQRT(-1)) = 0
Result (SUMCT)
Year |
Region |
Revenue |
SUMCT 'Revenue' |
---|---|---|---|
1999 |
North |
30 |
60 |
South |
30 |
60 |
|
Result 1999 |
60 |
180 |
|
2000 |
North |
60 |
120 |
South |
60 |
120 |
|
Result 2000 |
120 |
180 |
|
Overall Result |
180 |
180 |
Grand Total (SUMGT)
Year |
Region |
Revenue |
SUMGT 'Revenue' |
---|---|---|---|
1999 |
North |
30 |
180 |
South |
30 |
180 |
|
Result 1999 |
60 |
180 |
|
2000 |
North |
60 |
180 |
South |
60 |
180 |
|
Result 2000 |
120 |
180 |
|
Overall Result |
180 |
180 |
Query Result (Report Total) (SUMRT)
Year |
Region |
Revenue |
SUMRT 'Revenue' |
---|---|---|---|
1999 |
North |
30 |
180 |
South |
30 |
180 |
|
Result 1999 |
60 |
180 |
|
Overall Result |
60 |
180 |
The year 1999 is in the dynamic filter. The missing revenue 120 comes from the year 2000 (see SUMGT).
Process Value as Time (TIME)
This function is mainly intended for offset calculations. If, for example, you want to calculate 4 hours for time key figures then you can implement the operator TIME.