1 Reply Latest reply: Jun 20, 2014 3:10 PM by Stefan Wühl RSS

    First Sorted Value

    Isabel Nowinowski



      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!