NUMNODEC

Returns a numeric field value in character format, without decimal places.

Reporting Area(s)

Registrations, Accounting

Required Parameters

1. Numeric field to convert (e.g. rgcrsefee, pyamt)

Optional Parameters

2. Numeric return value. Set length of numeric value to return. Default is 8.
3. Character return value. Set the number of characters to pad the value. Default is 1 space.

Example(s)

NUMNODEC(rgcrsefee) returns registration course fee in character format without decimal places, e.g. 32500.

NUMNODEC(rgcrsefee,5) returns 5 characters of the registration course fee in character format without decimal places, e.g. 32500.

Related Functions

NUM2FRACTION
NUM2STR
STR
TRANSFORM
VAL