Skip to main content

 

Planview Customer Success Center

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

  • AED
  • AFN
  • ALL
  • AMD
  • ANG
  • AOA
  • ARS
  • AUD
  • AWG
  • AZN
  • BAM
  • BBD
  • BDT
  • BGN
  • BHD
  • BIF
  • BMD
  • BND
  • BOB
  • BRL
  • BSD
  • BTN
  • BWP
  • BYR
  • BZD
  • CAD
  • CDF
  • CHF
  • CLF
  • CLP
  • CNY
  • COP
  • COU
  • CRC
  • CUP
  • CVE
  • CZK
  • DJF
  • DKK
  • DOP
  • DZD
  • EEK
  • EGP
  • ERN
  • ETB
  • EUR
  • FJD
  • FKP
  • GBP
  • GEL
  • GHS
  • GIP
  • GMD
  • GNF
  • GTQ
  • GYD
  • HKD
  • HNL
  • HRK
  • HTG
  • HUF
  • IDR
  • ILS
  • INR
  • IQD
  • IRR
  • ISK
  • JMD
  • JOD
  • JPY
  • KES
  • KGS
  • KHR
  • KMF
  • KPW
  • KRW
  • KWD
  • KYD
  • KZT
  • LAK
  • LBP
  • LKR
  • LRD
  • LSL
  • LTL
  • LVL
  • LYD
  • MAD
  • MDL
  • MGA
  • MKD
  • MMK
  • MNT
  • MOP
  • MRO
  • MUR
  • MVR
  • MWK
  • MXN
  • MYR
  • MZN
  • NAD
  • NGN
  • NIO
  • NOK
  • NPR
  • NZD
  • OMR
  • PAB
  • PEN
  • PGK
  • PHP
  • PKR
  • PLN
  • PYG
  • QAR
  • RON
  • RSD
  • RUB
  • RUR
  • RWF
  • SAR
  • SBD
  • SCR
  • SDG
  • SEK
  • SGD
  • SHP
  • SKK
  • SLL
  • SOS
  • SRD
  • STD
  • SYP
  • SZL
  • THB
  • TJS
  • TMM
  • TND
  • TOP
  • TRY
  • TTD
  • TWD
  • TZS
  • UAH
  • UGX
  • USD
  • UYU
  • UZS
  • VEF
  • VND
  • VUV
  • WST
  • XAF
  • XCD
  • XOF
  • XPF
  • YER
  • ZAR
  • ZMK
  • ZWD
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
  • To use a specific date for the exchange rate in the above workflow rule, enter the date or reference to a field in the date parameter, and keep the project parameter as "null". CurrencyExchange($ActualCost,'EUR',$Startdate, null)
  • If both the date and project parameters are entered then the workflow rule will result in a run-time error
  • If both the date and project parameters are entered then the exchange rate date will be the current date
  • This function has a parameter from type pick list that may have being customized by your organization. Please refer to the pick list values in the formula helper editor or view the values within the relevant field.
Note This function is only available when the organization is set to use multi-currency
Additional Links

Multi-Currency