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

    First Sorted Value

    Isabel Nowinowski

      Hello,

       

      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!

       

      Thanks!

       

      Isabel