Dynamics NAV CAL - Flowfield to get last price, status or value based on max date

• Create two flowfields
• LastPriceDate = Max of the date column
• Save the table
• LastPrice = Price filtered on LastPriceDate = Date