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])