First page Back Continue Last page Image

Examples of Number functions

Function

ROUND(CTTD,2)

TRUNCATE(CTTD,2)

CEILING(CTTD)

FLOOR(CTTD)

ABS(CTTD)

SIGN(CTTD)

SQRT(CTTD)

POWER(CTTD,2)

RAND()

The blue portion of the function should be a Call To The Database (CTTD) like shown below

The purple portion (if required) is a configuration argument

Beyond this, these functions work the same way they do in programming languages or on a spreadsheet (like LibreOffice Calc)