# EXAMPLE - Numeric Functions

This example demonstrates how to use numeric functions to perform computations in your recipe steps.

Functions:

Item

Description

Returns the value of summing the first argument and the second argument. Equivalent to the + operator.

MOD Function

Returns the modulo value, which is the remainder of dividing the first argument by the second argument. Equivalent to the % operator.

NEGATE Function

Returns the opposite of the value that is the first argument. Equivalent to the - operator placed in front of the argument.

SUBTRACT Function

Returns the value of subtracting the second argument from the first argument. Equivalent to the - operator.

MULTIPLY Function

Returns the value of multiplying the first argument by the second argument. Equivalent to the * operator.

DIVIDE Function

Returns the value of dividing the first argument by the second argument. Equivalent to the / operator.

LCM Function

Returns the least common multiple shared by the first and second arguments.

Source:

ValueA

ValueB

8

2

10

4

15

10

5

6

Transformation:

Execute the following transformation steps:

 Transformation Name New formula Single row formula ADD(ValueA, ValueB) 'add'
 Transformation Name New formula Single row formula SUBTRACT(ValueA, ValueB) 'subtract'
 Transformation Name New formula Single row formula MULTIPLY(ValueA, ValueB) 'multiply'
 Transformation Name New formula Single row formula DIVIDE(ValueA, ValueB) 'divide'
 Transformation Name New formula Single row formula MOD(ValueA, ValueB) 'mod'
 Transformation Name New formula Single row formula NEGATE(ValueA) 'negativeA'
 Transformation Name New formula Single row formula LCM(ValueA, ValueB) 'lcm'

Results:

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

ValueA

ValueB

lcm

negativeA

mod

divide

multiply

subtract

8

2

8

-8

0

4

16

6

10

10

4

20

-10

2

2.5

40

6

14

15

10

30

-15

5

1.5

150

5

25

5

6

30

-5

5

0.833333333

30

-1

11