Currency

Converts the input parameter or parameters into a currency value. A currency value is a combination of the actual number value and the currency code, such as 3 USD.

Syntax

Currency(value,currencyCode)

Enabled for

Search/Dashboard	No
Business Rules	Yes
Quick Actions	Yes
Workflow Objects	Yes
Reports	No

Parameters

value

The value to be converted.

Notes:

If you include the optional currencyCode parameter, then this value parameter cannot be a currency image (which includes the currency code) because then you would specify the currency code twice; once here and once in the currencyCode parameter. If you include the optional currencyCode parameter, the value parameter must be a number or text value.

If you do not include the optional currencyCode parameter, this value parameter may or may not contain the currency code. The value parameter can be a currency image, or a number or text value.

If you do not include the optional currencyCode parameter and the value parameter does not contain the currency code, (that is, it is a number or text value), the system returns the value with the default currency code as specified in your user profile.
For example, to enter 21 USD, you could either enter $(Currency (21, USD) or $(Currency ("21 USD").

currencyCode

(Optional) The code value of the currency. See http://www.xe.com/iso4217.php for a list of ISO 4217 currency codes. You can only use this parameter if the value parameter does not contain a currency code.

Return Value

Currency value (a combination of the actual number value and the currency code, such as 3 USD).

If you only include the value parameter:
Returns a currency value if the value parameter is a currency image, such as "3USD" or "3.25JPY".
Returns a currency value with the default currency code if the value parameter is a number or text value, such as "4". The default currency code is set on the Application Setup page in the Configuration Console. See Account Information.

If you include both parameters:
Returns a currency value.

Returns an error if the value parameter is another type, such as DateTime, or if either of the input parameters are invalid.

Returns null if the value parameter is null.

Example

$(Currency(Cost + 10,USD))

If the value of the Cost field is 25, the above example returns "35 USD".