First Sorted Value

Anonymous — Fri, 20 Jun 2014 18:39:48 GMT

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

Re: First Sorted Value

swuehl — Fri, 20 Jun 2014 19:10:14 GMT

Both expressions don't seem correct to me. Could you check that there is no copy & paste issue here?

And if possible, please post a small sample app.