I need to create a Column with max on shipment status date and aggregate it to two fields by total keyword .

[joshna]

if(max (total< LH_PATIENT_ID, SERVICE_REQUEST>[Shipment Status Date])= [Shipment Status Date], 'Y', 'N')

Can anyone explain the logic?