# EXAMPLE - Rounding Functions

This example demonstrates how the rounding functions work together.

Functions:

Item

Description

FLOOR Function

Computes the largest integer that is not more than the input value. Input can be an Integer, a Decimal, a column reference, or an expression.

CEILING Function

Computes the ceiling of a value, which is the smallest integer that is greater than the input value. Input can be an Integer, a Decimal, a column reference, or an expression.

ROUND Function

Rounds input value to the nearest integer. Input can be an Integer, a Decimal, a column reference, or an expression. Optional second argument can be used to specify the number of digits to which to round.

MOD Function

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

Source:

rowNum

X

1

-2.5

2

-1.2

3

0

4

1

5

1.5

6

2.5

7

3.9

8

4

9

4.1

10

11

Transformation:

 Transformation Name New formula Single row formula FLOOR(X) 'floorX'
 Transformation Name New formula Single row formula CEILING(X) 'ceilingX'
 Transformation Name New formula Single row formula ROUND (X) 'roundX'
 Transformation Name New formula Single row formula (X % 2) 'modX'

Results:

rowNum

X

modX

roundX

ceilingX

floorX

1

-2.5

-2

-2

-3

2

-1.2

-1

-1

-2

3

0

0

0

0

0

4

1

1

1

1

1

5

1.5

2

2

1

6

2.5

3

3

2

7

3.9

4

4

3

8

4

0

4

4

4

9

4.1

4

5

4

10

11

1

11

11

11