How to display latest historical requisition status
Summary
I wrote two MAX statements, one for historical status and one for historical start date yet i get different results for requisitions with similar historyContent
I wrote the following two statments to filter to the most recent historical status of a requisition. Yet i get two different results for requistions with very similiar requisition history
MAX("Requisition Status - Historical"."Historical Status" by "Requisition Status - Historical"."Req. Historical Status Start Date")
MAX("Requisition Status - Historical"."Req. Historical Status Start Date" by "Requisition Identification"."Req. Identifier")
With no max statements you see this history as this:
Position_code |
0