I've figured out how to use index match to return a date associated with a document number but I can't figure out how to return the most recent date every time without sorting the data. The tables are linked to SQL so it's a refreshable report.
The formula is in Table1, column E
=INDEX(Table2[End Date], MATCH([@[No_]],Table2[Document No_],0))
I'm just not sure how to return the most recent date. EG: 3/16/15 for DRA-0000413 instead of whatever date is at the top of the data
Thanks for any help you can offer!
- Printed Field Tickets Report.xlsx (53.7 KB, 4 views)
Find Min and Max of Invoice and payment dates. By Barry Putman. This person is a verified professional. Also when the most recent payment was received from a client. This is for Crystal reports 2011 edition. I believe the logic would use the Minimum and the Maximum functions but when I use them in conjunction with other criteria it says.