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.

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.

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 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 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 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.

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 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 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 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.

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 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 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 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 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 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.

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.