I am trying to determine whether or not a vendor is Import or Domestic using the following expression:
FIRSTSORTEDVALUE ([PO Imp Dom], – aggr(max([PO Entry Date], [Vendor # (PO)]))).
I want to know if it is import or domestic based on the date of the last PO from the vendor. However, this expression does not work for me.
max([PO Entry Date], [Vendor # (PO)]) - This expression gives me the correct date of the last PO.
Any help would be greatly appreciated!