Number Equation Examples

Listed below are several examples of number equations demonstrating math functions in action.

ABS

The ABS function generates the absolute value of your numeric field. 

Below is a sample equation using the ABS function.

Below are the results of this sample equation using the ABS function.

CEIL

The CEIL function generates the ceiling value of your field. The expected input for this function is a single numeric value.

Below is a sample equation using the CEIL function.

Below are the results of this sample equation using the CEIL function.

FLOOR

The FLOOR function generates the floor value of your field. The expected input for this function is a single numeric value.

Below is a sample equation using the FLOOR function.

Below are the results of this sample equation using the FLOOR function.

ROUND

The ROUND function generates a value that is rounded, by default, to the nearest whole number.

This function has two different options for input:

1. Input with a single numeric value- value will be rounded to the nearest whole number (ROUND: Use Case 1)
2. Input with two numeric values- the first value in the function will be rounded to the nearest nth decimal place (ROUND: Use Case 2) 

ROUND: Use Case 1

Equation:

Results:

ROUND: Use Case 2

Equation:

Results where n = 3:

Results where n = -1:

SQRT

The SQRT function generates the square root of your numeric field value. The expected input for this function is a single numeric value.

Below is a sample equation using the SQRT function:

Below are the results of this sample equation using the SQRT function: