Skip to main content
Documentation
Documentation
Administrator Guide
Last Updated: 2023-06-23
Concept: Calculated Fields

Concept: Calculated Fields

Calculated fields are configurable field definitions associated with a business object that use data in Workday. You can view the data how and where you want it by performing arithmetic calculations, creating logical and conditional expressions, and transforming your data. Workday uses the standard order of operations rule, known as PEMDAS, for mathematic expressions:
  1. Parentheses
  2. Exponents
  3. Multiplication
  4. Division
  5. Addition
  6. Subtraction
Calculated fields enable you to work with data in your tenant on transactions throughout Workday, including:
  • Business processes.
  • Integrations.
  • Reporting.
  • Scheduled recurring processes.
You can select functions for different calculation requirements that enable you to:
  • Aggregate, group, or summarize data.
  • Concatenate a series of text fields within Workday.
  • Convert a currency to another currency.
  • Convert a text field number into a numeric data type.
  • Create date, numeric, or text fields and values to use as constant values in other calculations.
  • Determine if a condition is true or not.
  • Determine organizational role assignments.
  • Determine the appropriate range band for the value of a numeric field.
  • Determine the value of a field as of a specific date.
  • Drill down on an organizational hierarchy.
  • Enable users to enter values for Workday-delivered fields with built-in prompts.
  • Extract single instances or multiple instances, and either count or sum related instances.
  • Format date, numeric, and text fields.
  • Group and transform data by evaluating a series of boolean conditions.
  • List all instances associated with a source field related to the business object.
  • Perform simple mathematic calculations on currencies, dates, and numbers.
  • Retrieve data from related objects.
  • Return the number of characters and spaces in a single instance or text field.
  • Return the value of a field on a related business object.
  • Specify values for boolean conditions and return grouped instances.
  • Translate a text field into a specified language.
For numeric calculated field results, Workday displays up to 6 decimal places. For currency calculated field results, Workday adheres to ISO currency code standards to determine the number of decimal places. Example: If $10 ÷ $3 = 3.333333 (numeric), then $10 ÷ 3 = $3.33 USD (currency).