You are building a report that shows employee performance ratings and their associated performance review details. The report uses the Performance Review primary business object. Using a calculated field, what formula should you use to retrieve the employee's job title from the related Worker business object?

The Lookup Related Value (LRV) calculated field function is used to retrieve a field's value from a related business object. The question requires retrieving the Job Title (located on the Job Profile object, which is related to the Worker object) from a report based on the Performance Review primary business object. Since Performance Review is directly related to the Worker business object, an LRV function is the correct and most direct method to traverse this relationship and pull the desired field into the report.

A. Aggregate Related Instances: This function performs calculations (e.g., Count, Sum, Average) on a field across multiple instances of a related business object, not retrieve a single value.
C. Lookup Range Band: This function is used to categorize a value by determining which predefined numeric or date range it falls into, which is irrelevant for this task.
D. Evaluate Expression: This function is used to build conditional (if-then-else) logic. It is not the primary function for simply retrieving a value from a related object.

1. Workday Official Documentation: Calculated Fields Concepts. This guide details the various types of calculated field functions. The section on "Lookup Related Value" explicitly states its purpose: "Returns a value from a related business object. Use this function to pull information from a one-to-one or one-to-many (primary) related business object into your report." (Note: Access to Workday Community is required to view this document).

2. Workday Official Documentation: Reporting & Analytics Guide. In the chapter on "Calculated Fields

" the guide provides use cases for each function. The use case for Lookup Related Value consistently involves scenarios like the one described: starting on one business object (e.g.

Expense Report) and pulling in a related field (e.g.

Cost Center from the worker who submitted the report).

3. University of Washington

Integrated Service Center (ISC): Workday Reports – Calculated Fields. This university courseware document explains

"Lookup Related Value: This calculation is used to pull a value from a related Business Object into the report you are creating." It provides an example of pulling a Supervisory Organization onto a report whose primary business object is Worker

demonstrating the exact principle required by the question. (Reference: finance.uw.edu/isc/user-guides/reporting/workday-reports-calculated-fields)