Max Purchase Order Date Material Price

[atlantis_shahri]

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.

[sunny_talwar · Accepted solution]

May be this

FirstSortedValue(Price_Unit, -Order_Date_po)