I am trying to obtain the second to last date in a column with dates. I am using the below PQL ; where should I indicate that it has to pull up 2nd to last date?

Question

CASE WHEN (ROUND_DAY("PAYMENT_TABLE"."Payment registered date")) <

PU_MAX(DOMAIN_TABLE("PAYMENT_TABLE"."CG Key"), "PAYMENT_TABLE"."Payment registered date", ROUND_DAY("PAYMENT_TABLE"."Payment registered date") IS NOT NULL

)

THEN ROUND_DAY("PAYMENT_TABLE"."Payment registered date") ELSE NULL END

Page 1 / 1

Try the LAG() or LEAD() window functions, those will allow you to offset by N rows based on a sorting criteria.

Reply

deleted.delet17 · Answer

Try the LAG() or LEAD() window functions, those will allow you to offset by N rows based on a sorting criteria.

Reply

ANY QUESTION?

MORE CELONIS

CHECK US IN

Reply

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded

ANY QUESTION?

MORE CELONIS

CHECK US IN