RoundCurrency function

Syntax

RoundCurrency(amt, currency_cd, effdt) 

Description

Different currencies are represented at different decimal precessions. The RoundCurrency function is a rounding function that takes currency precision into account, using a value stored in the CURRENCY_CD_TBL PeopleTools table.

Parameters

Parameter Description

amt

The amount to be rounded.

currency_cd

The currency code.

effdt

The effective date of currency rounding.

Returns

Returns a Number value equal to amt rounded to the currency precision for currency_cd.

Example

The following example rounds 12.567 to 12.57, using the appropriate currency precision for US Dollars ("USD"):

&RESULT = RoundCurrency(12.567, "USD", EFFDT);