Skip to main content
Documentation
Documentation
Administrator Guide
Last Updated: 2023-06-23
Convert Currency

Convert Currency

  • Access the
    Maintain Currency Rate Types
     to configure additional currency rate types.
  • Access the
    Maintain Currency Conversion Rates
     task to configure conversion rates.
  • Security:
    Custom Field Management
     domain in the System functional area.
You can configure the calculated field to convert a currency to another currency. When you run the condition or report using this calculated field, Workday evaluates the currency rate time and date, then returns the appropriate exchange value. You can get a zero value or an error if:
  • The
    As Of Date Field
     has a blank value when the report runs.
  • Workday can't find data for the
    Source Currency Amount Field
    ,
    Target Currency Code Field
    , and
    Currency Rate Type
    .
  1. Access the
    Create Calculated Field
     task.
  2. Select
    Convert Currency
     from the
    Function
     prompt.
  3. As you complete the
    Calculation
     tab, consider:
    Option Description
    Source Currency Amount Field
    Select the field for the conversion value.
    Target Currency Code Field
    Select the currency code to apply.
    You can select a currency code, such as
    USD
    , or select
    Users Preferred Currency
    .
    As Of Date Field
    Select the field to calculate the exchange rate.
    The
    As Of Date Field
     and
    Currency Rate Type
     prompts enable Workday to determine what exchange to use for the conversion.
    Return Zero on Error
    Select the check box to return a zero value instead of displaying an error if the
    As Of Date Field
     returns a blank value.
You can use the convert currency calculated field to:
  • Convert an expense report total to a common currency for business process approval rules that depend on an amount.
  • Convert Canadian employee benefit contributions to USD for consolidated reporting with US benefit data.
  • Determine all employee bonuses in USD using the exchange rate in effect at the end of last year.
  • Display an employee's annual salary in EUR, regardless of how someone enters and stores it in Workday.
You can create:
  • Additional calculated fields.
  • New calculated fields from within a convert currency calculated field.
You can use the calculated field as an average aggregated numeric field on advanced, matrix, or trending reports. To display 12 decimal places for the calculated field, select
#,##0.000000000000
 or
#,##0.############
 as a format option on the:
  • Columns
     tab for advanced reports.
  • Matrix
     tab for matrix reports.
  • Trending
     tab for trending reports.
The formatting provides greater decimal precision for currency rates when you export reports to Excel or PDF.