summarize on last?

[becki]

hi folks, I want to check on the most efficient way to do this.  i need to find the latest date of revisions of a purchase order, to compare to the latest payment, on the PO.  i did a sort ascending, on both the PO and the revision number, then do summarize, take last of PO and revision number.  does this need to be done in two steps?  ( i ask because in ACL, it would be one summarize command).  thanks

becki kain

[MarqueeCrew]

@becki,

I'm sdrawkcab in my thinking.  I might approach this by use of different tools.

SORT: PO (asc), Rev# (Dec).

SAMPLE: Group by PO.  Get 1st record.

That's my take.

Cheers,

Mark

[becki]

still two steps though.  is that any faster? just curious on the speed of different commands.

and thanks!

[becki]

and thanks for the response!  I didn't know there was a Detroit group!  I just joined

[pcatterson · Accepted solution]

You should be able to do it with just the summarize.  If your dates are correct, you can use max to find the latest date.  Is that what you mean?

[MarqueeCrew]

@pcatterson is right that you can in one step

Groupby PO

Max Rev #

That is one step.

[becki]

well that's cool!  thanks!