BUILD_CURRENCY
Description
BUILD_CURRENCY
is a row function that constructs a Currency field from a numeric value and a Text or Instance value that contains a valid currency code. When the currency code isn't valid, this function returns NULL.Syntax
BUILD_CURRENCY
(number_expression
,currency_code_expression
)Return Value
Returns a value of type
CURRENCY
.Input Parameters
- number_expression
- Required. A field or expression of typeDOUBLE,NUMERIC,INTEGER, orLONG.
- currency_code_expression
- Required. A field or expression of typeTEXTorINSTANCEthat contains valid currency code data.
Examples
Convert the values of the Sale Price field (Numeric type) to a Currency field type using the currency codes from the Currency Code field:
BUILD_CURRENCY([Sale Price], [Currency Code])