In this article, you will learn all about the ten functions related to “Math”. To be precise, we will discuss the following functions:
Add
Add two values together

Select two elements that you want to add, or add a specified number to a single element
Ceiling
Round a specified element up to an integer
Select an element that you want to round up to an integer

Divide
Divide the numerator value by the denominator

numerator:
denominator:
format:
Connect “numerator” with the element that represents the top part of the fraction.
Connect “denominator” with the element that represents the bottom part of the fraction.
Optionally, specify a standard numeric format string (e.g., E02) that can be used to format the result of the division. (Default = null)
Floor
Round a specified element down to an integer
Select an element that you want to round down to an integer

Format Number
Change the format of a given number

number:
format:
link to the element you want to format
Specify a standard numeric format string (e.g., E02).
Get I S O Week Number
Get the ISO Week Number of a specific date
date:
dateFormat:
numberFormat:
Connect “date” with the element in your Source Schema that represents the date
Specify the format in which your date is structured, for example, yyyy-MM-dd
If you prefer a fixed number of digits, enter as many zeroes as your preference. (Default = week number without zeroes)

Make Negative
Convert a value to its negative counterpart

Connect to the element which you want to convert to a negative number
Multiply
Multiply values to obtain the product
Select the elements that you want to multiply, or multiply a specified number with an element

Round
Round a value to the nearest specified number of decimal places

srcValue
nofDecimals
Connect “srcValue” with the element you want to round
Specify the number of decimal places
Subtract
Subtract one value from another value
Select two elements that you want to subtract from each other, or subtract a specified number from a single element


Leave a comment