Page tree

Release 6.4.2


Contents:

   

Returns the value of subtracting the second argument from the first argument. Equivalent to the - operator.
  • Each argument can be a literal Integer or Decimal number, a function returning a number, or a reference to a column containing numeric values.

NOTE: Within an expression, you might choose to use the corresponding operator, instead of this function. For more information, see Numeric Operators.

 

Basic Usage

derive type:single value:SUBTRACT(10,4) as:'six'

Output: Subtracts the value 4 from 10 and stores the value in a new column called six

Syntax and Arguments

derive type:single value:SUBTRACT(value1, value2)

ArgumentRequired?Data TypeDescription
value1YstringThe first value must be an Integer or Decimal literal, column reference, or expression that evaluates to one of those two numeric types.
value2YstringThe first value must be an Integer or Decimal literal, column reference, or expression that evaluates to one of those two numeric types.

For more information on syntax standards, see Language Documentation Syntax Notes.

value1, value2

Integer or Decimal expressions, column references or literals to use in the subtraction.

  • Missing or mismatched values generate missing string results. 

Usage Notes:

Required?Data TypeExample Value
YesLiteral, function, or column reference returning an Integer or Decimal valuemyScore * 10

Examples


Tip: For additional examples, see Common Tasks.

Example - Numeric Functions

This example demonstrate the following numeric functions:

Source:

ValueAValueB
82
104
1510
56

Transform:

Execute the following transforms:

derive type:single value:ADD(ValueA, ValueB) as:'add'

derive type:single value:SUBTRACT(ValueA, ValueB) as:'subtract'

derive type:single value:MULTIPLY(ValueA, ValueB) as:'multiply'

derive type:single value:DIVIDE(ValueA, ValueB) as:'divide'

derive type:single value:MOD(ValueA, ValueB) as:'mod'

derive type:single value:NEGATE(ValueA) as:'negativeA'

derive type:single value:LCM(ValueA, ValueB) as:'lcm'

 

Results:

With a bit of cleanup, your dataset results might look like the following:

ValueAValueBlcmnegativeAmoddividemultiplysubtractadd
828-80416610
10420-1022.540614
151030-1551.5150525
5630-550.83333333330-111

See Also for SUBTRACT Function:

 

This page has no comments.