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:

  1. Numeric return value. Set length of numeric value to return. Default is 8.
  2. 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 Topics Link IconRelated Topics