MashZone NextGen 10.2 | Appendix | Operators | Data transformation operators | Arithmetic | Parameters
 
Parameters
The following parameters are available.
Action
Result
Operands
One numerical operand per operation for the "Square" and "Square root" calculation types, otherwise two numerical operands.
Source: Source table, constants, user input or incoming values from other operators.
Data type: Number
Specification: Mandatory
Calculation type
Addition (+)
Adds two columns row by row
Subtraction (-)
Subtracts 2 columns row by row
Division (/)
Divides the first column by the second column
Multiplication (*)
Multiplies two columns row by row
Percent (%)
Multiplies row by row the second column with the percent value of the first column
Square (x²)
Calculates the square of a column
Root
Calculates the square root of a column
Sine (sin)
Calculates for a column the sine value of an angle in degrees
Cosine (cos)
Calculates for a column the cosine value of an angle in degrees
Tangent (tan)
Calculates for a column the tangent value of an angle in degrees
Arcsine (asin)
Calculates for a column the arcsine of an angle in degrees
Arccosine (acos)
Calculates for a column the arccosine of an angle in degrees
Arctangent (atan)
Calculates for a column the arctangent of an angle in degrees
Logarithm (lg)
Calculates for a column the common logarithm
Logarithm (ln)
Calculates for a column the natural logarithm
Power (exp)
Calculates for a column S1 the S2nd power of S1 (S1 to the power of S2)
Minimum (min)
Calculates the minimum of column 1 and column 2
Maximum (max)
Calculates the maximum of column 1 and column 2
Absolute value (abs)
Calculates for a column the absolute value
Default value: Addition (+)
Specification: Mandatory
You need to specify the source values for the trigonometric functions sin, cos, tan, asin, acos, and atan in degrees.

Copyright © 2013-2018 | Software AG, Darmstadt, Germany and/or Software AG USA, Inc., Reston, VA, USA, and/or its subsidiaries and/or its affiliates and/or their licensors.
Innovation Release