@gclampitt Thank you! That works in my simple report. Now I just need to get it to work in my more complex multi-subject area report. When I add put the max formula in there, it just comes back blank…but that is probably just user error, lol. I will keep at it!

Yikes. Ok, thanks again. Sounds like that could have a big impact on performance, so not sure my team would want me changing that, lol.

Thanks. How do I remove the ORDER BY clause from the Advanced tab? Sorry, new to this!

Sure, here you go. Keep in mind this is just a test report for a larger report that needs those items. And I x'd out the person number. SET VARIABLE PREFERRED_CURRENCY='User Preferred Currency 1';SELECT 0 s_0, "Workforce Management - Person Real Time"."Worker"."Person Number" s_1, CASE "Workforce Management - Person Real…