Get Oldest Due Date

I need the oldest PO Due Date for the same product in Viz.

Report is filtered for PO stage at 1~ 3 (Ordered, Printed, Acknowledged), below image is the result I got when using expressions:

"Desc Duedt" - LOOKUPVALUE(0, [POEL.poel_shipprod], 1, SELECT [POEL.poel_shipprod], [POEL.poel_duedt] FROM [All] ORDER BY [POEL.poel_duedt] DESC)

"Asc Duedt" - LOOKUPVALUE(0, [POEL.poel_shipprod], 1, SELECT [POEL.poel_shipprod], [POEL.poel_duedt] FROM [All] ORDER BY [POEL.poel_duedt] ASC)

None of them give me the result I want - "04/26/2022" in this case.

If I add the PO stage into the expression, like below, I get blank result

LOOKUPVALUE(0, [POEL.poel_shipprod], 1, SELECT [POEL.poel_shipprod], [POEL.poel_duedt] FROM [All] WHERE [POEH.poeh_stagecd] <=3 ORDER BY [POEL.poel_duedt] DESC)

Is this LOOKUPVALUE the right approach?

Find more posts tagged with

Comments

Dan Rosen

yes, this is a valid approach, but if you are looking for a particular product, you need to add that to your where clause. I'm assuming the column [POEL.poel_shipprod] that you're passing in is your product, so in your where clause make it where [POEL.poel_shipprod] = %0. %0 indicates the first parameter you passed in (you can pass in multiple, %0, %1, etc.)

Dan Rosen

specifically, something like this: LOOKUPROW(0,0,[POEL.poel_shipprod], SELECT [POEL.poel_duedt] FROM [All] WHERE [POEL.poel_shipprod] = %0 ORDER BY [POEL.poel_duedt] DESC)

Dan Rosen

Or ASC for earliest*

Legacy Contributor

Thank you Dan for the quick response, but the result remain the same when I add the where clause, regardless DESC or ASC.

Copyright © 2025 Infor. All rights reserved.