SUB
Applies to: CELONIS 4.0 CELONIS 4.2 CELONIS 4.3 CELONIS 4.4 CELONIS 4.5 CELONIS 4.6
Description
The subtraction operator computes the difference of two values.
The subtraction operator can be applied to INT or FLOAT columns or constants. The resulting column is of type INT if both input columns or constants are of type INT. In all other cases, the resulting column is of type FLOAT.
Syntax
SUB ( table.column1 , table.column2 )
table.column1 - table.column2
Examples
[4] Subtract values of multiple INT and FLOAT columns.
|