You are building a report that shows employee performance ratings and their associated performance review...

The correct choice isLookup Related Value, because this function allows you to retrieve a field from a related business object that is not directly stored on your primary object. In this scenario, theprimary business object is Performance Review, which holds performance-related data but not job-related data such as Job Title. Since Job Title resides on theWorker business object, you need to link from Performance Review to Worker and then retrieve Job Title.

The Workday reporting guide explains:“Lookup Related Value – Returns a field from a related business object. Use this to bring data from associated objects into a report when the field is not directly available on the primary object.”. This ensures the Performance Review data can be combined with Job Title for meaningful insights.

By contrast, Aggregate Related Instances is used to roll up multiple related values, Range Band applies thresholds, and Evaluate Expression Band is used for conditional ranges, not cross-object retrieval.