Skip to main content
Administrator Guide
Last Updated: 2023-06-23
Arithmetic Calculation

Arithmetic Calculation

  • Create the numeric constants that you want to use in the calculated field.
  • Security:
    Custom Field Management
    domain in the System functional area.
You can set up the calculated field to derive values from currency or numeric fields by performing these simple arithmetic calculations:
  • Addition
  • Subtraction
  • Multiplication
  • Division
Self-referencing fields cause exceptions with this calculated field. You can determine if your calculated field is self-referencing by accessing
Calculated Field
View Calculation Hierarchy
from the related actions menu of the calculated field.
  1. Access the
    Create Calculated Field
    task.
  2. Select
    Arithmetic Calculation
    from the
    Function
    prompt.
  3. As you complete the
    Calculation
    tab, consider:
    Option Description
    Field Type
    If you select
    Currency
    , all fields in the calculation must have the same currency code.
    Rounding
    Unless you select an option, Workday applies
    round half up
    when there are 6 decimal places. Example: 2.123456 rounds half up to 2.124.
    Workday performs rounding after each set of division and multiplication, so a group of numbers might not add up to the total displayed.
    If the
    Field Type
    is
    Currency
    , Workday doesn't perform any rounding.
    Currency Code Field
    If the
    Field Type
    is
    Currency
    , specify a currency code, such as EUR or USD. The
    Currency Code Field
    and currency codes for the currency fields in the calculation must match.
    Return Zero on Error
    Select the check box to return a zero value instead of displaying an error if the calculated field attempts to divide by zero.
    If you use a Prism business object with this calculated field, Workday always returns a zero on error.
  4. As you complete the
    Arithmetic Expression
    grid, consider:
    Option Description
    Parentheses
    You can configure up to 9 levels of parentheses for calculations with:
    • Multiple operations.
    • Operations requiring a specific order.
    Field
    Available field options depend on the business object that you select.
You can use arithmetic calculations to calculate a worker's:
  • Daily, hourly, monthly, or weekly rate.
  • Salary difference from this year compared to last year.
  • Salary range penetration percentage.
You can also calculate 20% of a worker's salary to compare it against their bonus amount.
You can create:
  • Additional calculated fields.
  • New calculated fields from within an arithmetic calculation calculated field.