Numeric Functions

Numeric functions are available from the Math Function menu. They operate on numeric values to round numbers up or down, truncate them, or determine whether the number is negative or positive. These functions are available for every data provider except for raster, WFS, and WMS providers.

When you create an expression for geospatial features, you can use the following numeric functions:

Function Definition Syntax Example

CEIL

Rounds a number up to the next highest integer. The return value uses the input data type.

For example, CEIL(2.6)=3

CEIL(-2.6)=-2

CEIL(Numeric_Property)

CEIL(Part_Cost)

FLOOR

Rounds a number down to the next lowest integer. The return value uses the input data type.

For example, FLOOR(2.6)=2

FLOOR(-2.6)=-3

FLOOR(Numeric_Property)

FLOOR(Part_Cost)

ROUND

Rounds a number to the specified decimal places. The return value uses the input data type.

For example, ROUND(1.476,2)=1.48

ROUND(Numeric_Property], Number of decimal places)

ROUND(Part_Cost,2)

SIGN

Finds the sign of a number. Returns 1 if the number is positive; 0 if the number is 0; -1 if the number is negative. The return value uses an Int16 data type.

For example, SIGN(-3.76)=-1

SIGN(Numeric_Property)

SIGN(Parcel_Sale_Profit)

TRUNC

Truncates a date property to the specified format ('YEAR', 'MONTH', 'DAY', 'HOUR' or 'MINUTE')

or

Truncates a numeric property to the specified number of decimal places. The return value uses the input data type.

For example, TRUNC(1.476, 2)=1.47

This function returns a DOUBLE.

TRUNC(Date_Property, 'Format')

TRUNC(Numeric_Property, Number of decimal places)

TRUNC(Repair_Date, 'DAY')

or

TRUNC(Repair_Cost, 2)