Skip to content

PRETTYNUM

Removes trailing 0 decimals from specified numeric field. For use on Certificate reports.

Reporting Area(s)

Registrations, Certificates

Required Parameters

  1. Numeric field (i.e. rgceus, rghours)

Optional Parameters

None

Example(s)

PRETTYNUM(rgceus) if rgceus is 2.500, returns 2.5.

FULLCENT
NUM2FRACTION
NUM2STR
NUMNODEC
ROUND
STR