I'm fairly new writing these defined fuctions in WEBFOCUS and need a little help. I want to run a report that flags duplicates that are present in two status', "cancelled" and "Settled". I attempted the below but got stumped at the DocID_Buyer portion. Can anyone help?


IF BTL.BT_LINE.PTN_FinancialStatus_Code EQ 'PS' 'CA' AND BTL.BT_LINE.DocID_Buyer EQ '99999999999999999' THEN 'DUPE' ELSE 'N'

Note:
The BTL.BT_LINE.DocID_Buyer is where I want to find the Dupe's

BTL.BT_LINE.PTN_FinancialStatus_Code are the two status' each docID can be in the system with 'PS'=Settled and 'CA'=Cancelled

Happy New Year to all!

This message has been edited. Last edited by: Mike321,

Finding duplicate records often involves counting records based on your filter criteria and then applying a WHERE TOTAL test at the end. A second verb request (PRINT or SUM depending on the circumstances) is used to display the duplicate records. For example:

TABLE FILE <filename>
 COUNT BTL.BT_LINE.DocID_Buyer NOPRINT
    BY BTL.BT_LINE.DocID_Buyer
 WHERE (BTL.BT_LINE.PTN_FinancialStatus_Code EQ 'PS' OR 'CA');
 WHERE TOTAL COUNT GT 1 ;
 PRINT BTL.BT_LINE.PTN_FinancialStatus_Code
    BY BTL.BT_LINE.DocID_Buyer
END

Thanks Dan and appreciate the guidance.

[solved]