Max Function

[Anonymous]

Hello,

In an expression, I am trying to determine whether a SKU is Import or Domestic with the field, [PO Imp/Dom] which will give me either "I" or "D" for the last [PO Entry Date]. I would like to know how to determine whether or not a SKU is an "I" or a "D" based on the max [PO Entry Date].

Any help would be greatly appreciated!

Isabel

[venkatg6759 · Accepted solution]

Use firstsorted value 

Firstsortedvalue([PO Imp/Dom] ,-[PO Entry Date])

[Anonymous]

Thanks!

[eduardo_sommer]

Use this:

if(firstsortedvalue([PO Imp/Dom ], -[PO Entry Date])='I', 'Imported', 'Domestic')

Eduardo