Numeric functions
The numeric function are listed next (we only specify the MS-SQL Server version of the interpretation of the functions):
Option name in the popup list |
Inserted string (where Fld is the selected field) |
Absolute Value |
ABS(Fld) |
Ceiling |
CEILING(Fld) |
Floor |
FLOOR(Fld) |
Round |
ROUND(Fld, nLen, 0) |
Truncate |
ROUND(Fld, nLen, 1) |
Sign |
SIGN(Fld) |