(v23) Numerical Functions

Numerical Functions

This applies to: Visual Data Discovery

Function	Description	Example
CEIL	Returns the smallest integer value that is not less than the passed Value	CEIL(value : Numeric) : Numeric CEIL(Field_A)
FLOOR	Returns the largest integer value that is not greater than the passed value	FLOOR(value : Numeric) : Numeric FLOOR(Field_A)
NUM_TO_TEXT	Converts the numeric expression to text	NUM_TO_TEXT(value : Numeric) NUM_TO_TEXT(Field_A)
ROUND	Rounds a numeric value to the number of decimals specified	ROUND(Field_A, 0)
UNIX_TIME_TO_TIME	Converts the numeric expression to time	UNIX_TIME_TO_TIME(Field_Milliseconds / 1000)