First Sorted Value

[Anonymous]

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

[swuehl]

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.