Including latest requisition comment into reporting
Content
Hi Community!
I am trying to bring the latest comment against a requisition into a report - I can find the comments and the dates of the comments, but am finding it a challenge to bring back only the latest comment.
I have created a "days between" count between the comment date and the current date (C: days since last comment) - but when I do a "Min" on this for "Each Requisition" it continues to bring back all the days between counts and not the minimum for the requisition.
=Min(([C: days since last comment])ForEach([Requisition NO & Title (ML)]))