2.0

Functions
9-28 Using Calculations
Round
The Round function returns the value of a number or numeric
expression rounded to the specified decimal places in the second
parameter.
Usage Example
Round([num1], num of decimal places)
If the field [num1] = 2404.685
Then the calculation Round([num1],2) returns 2404.68
In the example below, the value in the
To ta l
field is extracted and
rounded to two decimal places in the
Price
field.
Second
The Second function returns the second (SS) portion of a given time
(HH:MM:SS). The second ranges from 0–59.
Usage Example
Second(Time())
If the current time is 18:05:05
Then the calculation Second(Time()) returns 5
In the example below, the seconds are extracted from the
Time
field and
placed in the
Second
field.