Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Example
In this example, we are passing a decimal value to the function transformation object using a Variables object.
Where,
number = 12.34
In the output window, you can see that the floor value, 12, has been returned for the provided number value.
Name
Floor (Decimal)
Syntax
Floor (Decimal number)
Purpose
To return the largest integer equal to or less than the number specified.
Description
Rounds to the largest integer equal to or less than the number specified
Return Type
Integer
Parameters
number [System.Decimal] – Number for which the floor value will be returned
Example
In this example, we are passing a real value to the function transformation object using a Variables object.
Where,
number = -12.34
In the output window, you can see that the ceiling value, -12, has been returned for the provided number value.
Example
In this example, we are passing a decimal value to the function transformation object using a Variables object.
Where,
number = 12.34
In the output window, you can see that the ceiling value, 13, has been returned for the provided number value.
Name
Ceiling (Real)
Syntax
Ceiling (Real number)
Purpose
To return the smallest integer greater than or equal to the number specified.
Description
Returns the smallest integer greater than or equal to the number specified.
Return Type
Integer
Parameters
number [System.Double] – Number for which the ceiling value will be returned
Name
Ceiling (Decimal)
Syntax
Ceiling (Decimal number)
Purpose
To return the smallest integer greater than or equal to the number specified.
Description
Returns the smallest integer greater than or equal to the number specified.
Return Type
Integer
Parameters
number [System.Decimal] – Number for which the ceiling value will be returned
Example
In this example, we are passing decimal values to the function transformation object using a Variables object.
Note: This function also takes into account negative values.
Where,
first = 1.23
second = 3.21
In the output window, you can see that the smaller decimal value has been returned.
Example
In this example, we are passing integer values to the function transformation object using a Variables object.
Note: This function also takes into account negative values.
Where,
first = 1234
second = 4321
In the output window, you can see that the greater integer value has been returned.
Example
In this example, we are passing a real value to the function transformation object using a Variables object.
Where,
number = -12.34
In the output window, you can see that the floor value, -13, has been returned for the provided number value.
Example
In this example, we are passing negative double value to the function transformation object using a Variables object.
Where,
number = -1234
In the output window, you can see that the absolute value, 1234, has been returned for the provided number value.
Example
In this example, we are passing DateTime values to the function transformation object using a Variables object.
Where,
first = 09/08/1998
second = 05/04/1995
In the output window, you can see that the earlier date of the two provided date values has been returned.
Let’s now pass the same date values, but with different time values.
Where,
first = 09/08/1998 02:50:40 AM
second = 09/08/1998 02:50:50 AM
In the output window, you can see that the earlier datetime of the two provided datetime values has been returned.
Example
In this example, we are passing real values to the function transformation object using a Variables object.
Where,
first = -1234
second = 4.321
In the output window, you can see that the greater real value has been returned.
Example
In this example, we are passing decimal values to the function transformation object using a Variables object.
Note: This function also takes into account negative values.
Where,
first = 1.23
second = 3.21
In the output window, you can see that the greater decimal value has been returned.
Name
Min (Decimal)
Syntax
Min (Decimal first, Decimal second)
Purpose
To return the smaller of two decimal values.
Description
Returns the minimum of two decimal values.
Return Type
Decimal
Paramaters
first [System.Decimal] – First value
second [System.Decimal] – Second value
Name
Max (Integer)
Syntax
Max (Integer first, Integer second)
Purpose
To return the greater of two integer values.
Description
Returns the maximum of two integer values.
Return Type
Int64
Parameters
first [System.Int64] – First value
second [System.Int64] – Second value
Name | Floor (Real) |
Syntax | Floor (Real number) |
Purpose | To return the largest integer equal to or less than the number specified. |
Description | Rounds to the largest integer equal to or less than the number specified |
Return Type | Integer |
Parameters | number [System.Double] – Number for which the floor value will be returned |
Name | Abs (Real) |
Syntax | Abs (Real number) |
Purpose | To return the absolute value of a given number. |
Description | Returns the absolute value for the given number. |
Return Type | Real |
Parameters | number [System.Double] – Number for which the absolute value will be returned |
Name | Min (Date) |
Syntax | Min (Date first, Date second) |
Purpose | To return the earlier of two date values. |
Description | Returns the minimum of two date values. |
Return Type | DateTime |
Parameters | first [System.DateTime] – First value second [System.DateTime] – Second value |
Name | Max (Real) |
Syntax | Max (Real first, Real second) |
Purpose | To return the greater of two real values. |
Description | Returns the maximum of two real values. |
Return Type | Real |
Parameters | first [System.Double] – First value second [System.Double] – Second value |
Name | Max (Decimal) |
Syntax | Max (Decimal first, Decimal second) |
Purpose | To return the greater of two decimal values. |
Description | Returns the maximum of two decimal values. |
Return Type | Decimal |
Parameters | first [System.Decimal] – First value second [System.Decimal] – Second value |
Example
In this example, we are passing DateTime values to the function transformation object using a Variables object.
Where,
first = 09/08/1998
second = 05/04/1995
In the output window, you can see that the later date of the two provided date values has been returned.
Let’s now pass the same date values, but with different time values.
Where,
first = 09/08/1998 02:50:40 AM
second = 09/08/1998 02:50:50 AM
In the output window, you can see that the later datetime of the two provided datetime values has been returned.
Example
In this example, we are passing negative decimal value to the function transformation object using a Variables object.
Where,
number = -1.234
In the output window, you can see that the absolute value, 1.234, has been returned for the provided number value.
Example
In this example, we are passing real values to the function transformation object using a Variables object.
Where,
first = -1234
second = 4.321
In the output window, you can see that the smaller real value has been returned.
Example
In this example, we are passing integer values to the function transformation object using a Variables object.
Where,
first = 1234
second = 4321
In the output window, you can see that the smaller integer value has been returned.
Example
In this example, we are passing a real value to the function transformation object using a Variables object.
Where,
number = -12.3456
In the Data Preview window, you can see that the specified real value has been rounded to its nearest integer value i.e., -12.
Example
In this example, we are passing min and max values to the function transformation object using a Variables object.
Where,
min = 1
max = 5
In the Data Preview window, you can see that a random real value, which falls within the provided min and max values, has been generated.
Example
In this example, we are passing base and exponent values to the function transformation object using a Variables object.
Where,
base = 5
exponent = 3
In the Data Preview window, you can see that the returned value, 125, is the base value, 5, raised to the exponent value, 3.
Name
Max (Date)
Syntax
Max (Date first, Date second)
Purpose
To return the later of two date values.
Description
Returns the maximum of two date values.
Return Type
DateTime
Prameters
first [System.DateTime] – First value
second [System.DateTime] – Second value
Name
Abs (Decimal)
Syntax
Abs (Decimal number)
Purpose
To return the absolute value of a given number.
Description
Returns the absolute value for the given number.
Return Type
Decimal
Parameters
number [System.Decimal] – Number for which the absolute value will be returned
Name
Min (Real)
Syntax
Min (Real first, Real second)
Purpose
To return the smaller of two real values.
Description
Returns the minimum of two real values.
Return Type
Real
Parameters
first [System.Double] – First value
second [System.Double] – Second value
Name
Min (Integer)
Syntax
Min (Integer first, Integer second)
Purpose
To return the smaller of two integer values.
Description
Returns the minimum of two integer values.
Return Type
Int64
Parameters
first [System.Int64] – First value
second [System.Int64] – Second value
Name
Round (Real)
Syntax
Round (Real number)
Purpose
To round a given number
Description
Rounds a real number to the nearest integer value.
Return Type
Integer
Parameters
number [System.Double] – Number for which the rounded value will be returned
Name
RandomReal
Syntax
RandomReal (Integer min, Integer max)
Purpose
To generate a random number.
Description
Generates a random number within a range defined by min and max values.
Return Type
Real
Parameters
min [System.Int32] – Minimum number to return
max [System.Int32] – Maximum number to return
Name | Pow |
Syntax | Pow (Real base, Real exponent) |
Purpose | To return base value raised to the power signified by the exponent value. |
Description | Returns base raised to power exponent |
Return Type | Real |
Parameters | base [System.Double] – Base value exponent [System.Double] – Exponent value |
Example
In this example, we are passing a decimal value and an integer value (to specify decimal places) to the function transformation object using a Variables object.
Where,
number = 12.3456789
decimals = 3
In the Data Preview window, you can see that a value, truncated to the specified number of decimal places, has been generated.
Example
In this example, we are passing a decimal value to the function transformation object using a Variables object.
Where,
number = 12.345
In the Data Preview window, you can see that the rounded value, 12, has been generated.
Example
In this example, we are passing a real value and an integer value (to specify decimal places) to the function transformation object using a Variables object.
Where,
number = -12.3456789
decimals = 3
In the Data Preview window, you can see that a value, rounded to the specified number of decimal places, has been generated.
Name
Round (Decimal-Integer decimals)
Syntax
Round (Decimal number, Integer decimals)
Purpose
To round a given number to a specified number of decimal places.
Description
Rounds a given number to the specified number of decimal places.
Return Type
Real
Parameters
number [System.Decimal] – Number for which the rounded value will be returned
decimals [System.Int64]
Name
Round (Decimal)
Syntax
Round (Decimal number)
Purpose
To round a given number
Description
Rounds a decimal to number to the nearest integer value.
Return Type
Integer
Parameters
number [System.Decimal] – Number for which the rounded value will be returned
Name
Round (Real-Integer decimals)
Syntax
Round (Real number, Integer decimals)
Purpose
To round a given number to a specified number of decimal places.
Description
Rounds a given number to the specified number of decimal places.
Return Type
Real
Parameters
number [System.Double] – Number for which the rounded value will be returned
decimals [System.Int64]
