Subtract

Logic Name

Subtract

Function

Subtracts the input number below from the input number above and returns the result.

Data Types

Location Type
The first input handler Numeric
The second input handler Numeric
Logic output Numeric
lightbulbRefer to "Logic Specifications" for details.

Properties

Category Property Description
Required Input count Specify input count by 2 or more.
Precision Specify precision Select whether to directly specify the decimal places of precision in decimal type calculation.
Precision Specified digits Directly specifies the number of decimal places in decimal type precision.
Precision Rounding Specify the method of rounding.
Null processing Null option Specify how to handle the input if it contains null.
Comment Comment The comment will also be output to the specifications.It does not affect the conversion process.

Null option

Option Description
Convert null into 0 Converts null to 0 and continue with the process.
Throw exception when unable to determine/calculate/process Throws exception (CalculationException) when unable to determine/calculate/process.
Output null if either of input handler is null Outputs null if the value of any input handler is null.
lightbulbRefer to "Logic Specifications" for details.

Function Details

About input count

You need enter a number greater than or equal to "2" in [Input count]. The number of input handlers varies depending on the value of [Input count].
lightbulbThe recommended maximum value of [Input count] is "100". When you subtract 100 or more numbers, use multiple Subtract logics.

Notes

Logic Sample

Mapping Definition

Logic Settings and Processing Result

The logic subtracts the value of "column[2]" from the value of "column[1]" of input data and output the result.
Property Settings
Property Setting
Input count 2
Specify precision Not Checked
Specified digits  
Rounding Round to 0.
Null option Convert null into 0
Input Data
10,3
10,3.0
10.0,3
Result Data
7
7.0
7.0