Skip to main content
Documentation
Documentation
Administrator Guide
Last Updated: 2023-12-15
Evaluate Expression

Evaluate Expression

  • Create the date, numeric, or text constants that you want to use in the calculated field.
  • Ensure the conditions and values that you want to evaluate already exist for the business object.
  • Security:
    Custom Field Management
     domain in the System functional area.
You can configure the calculated field to group and transform data by evaluating a series of true/false conditions. Workday:
  • Evaluates the conditions sequentially.
  • Returns the value that you specify for true conditions, or the
    Default Value
     for all false conditions.
  • Stops testing when it yields a true condition.
  1. Access the
    Create Calculated Field
     task.
  2. Select
    Evaluate Expression
     from the
    Function
     prompt.
  3. On the
    Calculation
     tab, select an option from the
    Field Type
     prompt.
    Except for multi-instance and single instance field types, Workday uses your
    Field Type
     selection to determine the field types available on the
    Return Value If Condition is True
     prompt. Example:
    • Text field types yield text options, date field types yield date options, numeric field types yield numeric options, and so on.
    • Multi-instance field types yield multi-instance, single instance, and self-referencing options.
    • Single instance field types yield single instance and self-referencing options.
    When you select
    Multi-Instance
     or
    Single Instance
    , Workday evaluates boolean conditions against your choice from the
    Business Object
     prompt. You can use the resulting calculated field as a business object in a report.
  4. Select an option from the
    Default Value
     prompt to return when the condition is false.
  5. In the grid, select an option from the
    Condition
     prompt so Workday can evaluate the conditions sequentially as true or false.
  6. Select an option from the
    Return Value If Condition is True
     prompt that displays if the condition is true.
You can group and transform data to display the:
  • Age group.
  • Employment status.
  • Management status.
  • Seniority category based on length of service.
You can create an evaluate expression calculated field using the Worker business object to display the employment status of an employee. On the
Calculation
 tab, select:
Prompt
Value
Field Type
Text
Business Object
Worker
Default Value
Empty String
In the grid, select:
Condition
Return Value If Condition is True
Worker Active
Active
On Leave
On Leave
Worker Retired
Retired
Worker is Terminated (but not Retired)
Terminated
You can create an evaluate expression calculated field using the Supplier Invoice Line business object to display supplier payee details. On the
Calculation
 tab, select:
Prompt
Value
Field Type
Single Instance
Business Object
Payee
Default Value
Empty Instance
In the grid, select:
Condition
Return Value If Condition is True
Supplier is not empty
Supplier as Worktag
Contingent worker is not empty
Contingent Worker
You can create:
  • Additional calculated fields.
  • New calculated fields from within an evaluate expression calculated field.