I’ve seen a few forums on here that address something similar but none that exactly addresses my issue or gives a clear answer.
I have a series of price entries in a table called RFQ/PO Items.
I have a Lookup on a table called Supplier SKUs that looks up each of the prices on the RFQ/PO Items table.
I have a Lookup on the Supplier SKUs table that looks up each of the Dates on the RFQ/PO Items table.
I have a Roll-up on the Supplier SKUs table that looks at the MAX(values) to return the latest Date from RFQ/PO Items.
What I’d like to have is something that let’s me see just the latest Price. So, if there are three prices, $5, $8, and $6 on 1/1/2022, 2/1/2022, and 3/1/2022, respectively, I would like the rollup to return the value “$6”.
Thanks in advance for your help!