CurrencyExchange Function
CurrencyExchange (currency as Currency, targetCurrency as ObjectIdentifier, date as DateTime, project as ObjectIdentifier) as Currency
Category: | Currency |
Description: | Converts a currency amount to a specified currency, where the date parameter indicates the exchange rate date, if no specific date then a "Null" value can be entered. The project parameter indicates either a specific project exchange rate or the exchange rate date set on the specified project, if no specific project then a "Null" value can be entered. |
Supported Context: | FormulaField And BusinessRules |
Parameters: | |
currency as Currency | A currency amount, or reference to a field that returns a currency value |
targetCurrency as ObjectIdentifier(CurrencyType) |
Represents the desired target currency type. Accepts three letter currency code (such as "USD")
|
date as DateTime | Represents the value of the desired exchange rate date, value must be of type date or reference to a field of type date. If no specific exchange rate date then enter a value of "Null" |
project as ObjectIdentifier(Project) | Represents the value of the desired exchange rate or exchange rate date as set in a specific project, value must be a relation to a specific project object. If no specific project exchange rate then enter a value of "Null" |
Returned value as Currency | Returns the currency value equal to the amount inputted in the "Currency" parameter converted to the currency specified in the "Target Currency" parameter using the exchange rate defined in either the "Date" or "Project" parameters |
Example #1 |
Create a workflow rule that will automatically convert the Actual Cost of a work item from 'USD' to 'EUR', based on the project exchange rate, and enter the 'EUR' value into a custom field for billing purposes. In the Workflow rule select the run time to be every time a record is created or edited and set the evaluation criteria to: IsChanged($ActualCost) Select the "Update Field" action and choose the custom field mentioned above. In the formula enter the following: CurrencyExchange($ActualCost,'EUR',null,$Project) In the example above the organization's base currency is in USD |
Tips |
|
Note | This function is only available when the organization is set to use multi-currency |
Additional Links |