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
FLOOR	Returns the largest integer value that is not greater than the passed value	FLOOR (value : Numeric) : Numeric
NUM_TO_TEXT	Converts the numeric expression to text	NUM_TO_TEXT (value : Numeric)
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)