Help creating flag

[#1]

Hi All,

I am running into an issue and now sure how to resolve it.

Problem: For a O_PNumber , once New_Business_Flag is identified, I need look at all transaction for that PO and flag transaction where Calendar_Date > Calendar_Date of Transaction with as New_business_Flag to achieve Desired Result as show in image below.

Can someone please help? Attached is the xls file and qvw file for this scenario.

Thank you.

Pranita

[#2 · Accepted solution]

hi,

you can find attached the qvw with the desired result.

check the script modification.

[#3]

Thank you . This works perfectly!!