Reporting on Most Recent Req. Comment

Summary

Most Recent Req. Comment

Content

Hi,

Has anyone successfully reported on the most recent req. comment? Our recruiters use Req. Comments as a means to keep the business informed on the progress of the req. and would like to report on it. We have an open req. report we would like to add this to. However, the formula MAX("Requisition Tracking History"."Transaction User Comments" by "Requisition Identification"."Req. Identifier") does not pull the most recent comment. It seems to have no rhyme or reason as to what comment in the history tab it pulls!! I've also tried this formula and still doesn't pull the most recent comment left: FILTER(MAX("Requisition Tracking