Max Purchase Order Date Material Price

atlantis_shahri — Mon, 25 Jun 2018 12:52:01 GMT

I want to find out the last purchase date material price. I can easily find out the max purchase date but I need the material price of that date too.

1. Max Purchase Date=Max(Order_Date_po)

2. Max date Price=Only({$<Order_Date_po={"=Max(Order_Date_po)"}>}Price_Unit)

If I add Po No then all the entries are shown. But that doesn't serve my purpose.

Please help. Thanks in advance.

Re: Max Purchase Order Date Material Price

sunny_talwar — Mon, 25 Jun 2018 12:56:12 GMT

May be this

FirstSortedValue(Price_Unit, -Order_Date_po)