You are configuring a matrix report that shows workers' average base pay by job profile. You would like to add a field to the Detail Data that shows…

The Lookup Related Value (LRV) calculated field function is designed to retrieve the value of a field from a related business object. In this scenario, the report's primary business object is likely 'Worker'. The 'Worker' business object has a single-instance field that links to the 'Job Profile' business object. To display the 'Compensation Group' (a field on the 'Job Profile' object) on the report, an LRV calculated field is used to "look up" this value through the established relationship.

A. Evaluate Expression: This function is used to create conditional (if-then-else) logic or perform calculations based on fields within the same business object instance, not to retrieve data from a related object.

B. Extract Single Instance: This function is used to return a single instance from a multi-instance related business object field (e.g., a worker's job history). 'Job Profile' on a worker is typically a single-instance relationship.

D. Lookup Hierarchy: This function is specifically designed to navigate and retrieve data from hierarchical structures, such as supervisory or organization hierarchies, not for general related business objects like Job Profile.

1. Workday Official Documentation

"Calculated Fields: Reference Guide": This guide details the purpose and configuration of all calculated field types.

Section: Lookup Related Value: "Use the Lookup Related Value calculated field to retrieve a value from a related business object... For example

you can create a calculated field on the Worker business object that returns the Job Family Group for the worker's job profile." This directly mirrors the question's scenario.

Section: Evaluate Expression: Describes its use for returning a value based on a series of ordered conditions.

Section: Extract Single Instance: Explains its function is to "return a single instance from a related multi-instance business object."

Section: Lookup Hierarchy: States its purpose is to "return a value from a business object in a hierarchical structure."

2. Workday Official Documentation

"Report Writer and Calculated Fields Training Manual": This training material provides practical examples and use cases for building reports and calculated fields.

Chapter: Creating Calculated Fields: The section on Lookup Related Value provides step-by-step instructions for creating a field that pulls information from a related object

such as retrieving a 'Job Level' from a 'Job Profile' when the primary business object is 'Worker'. This is functionally identical to the question's requirement.