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) |