Hi there,

 

I have a problem where for reasons cannot be changed, I’m getting duplicate data in a group.

I need to overwrite the values of the duplicate quantities and values/invoice amount to zero.

 

Does anyone know how to do this?

 

Example:

 

Invoice No.	Invoice Line	Invoiced Qty	Invoice Line Amt.
567506	1	8.00	83.04
567506	1	8.00	83.04
567506	2	2.00	20.76
567506	2	2.00	20.76
		20.00	207.60

 

 

Resolution:

 

Invoice No.	Invoice Line	Invoiced Qty	Invoice Line Amt.
567506	1	8.00	83.04
567506	1	0	0
567506	2	2.00	20.76
567506	2	0	0
		10.00	103.80

 

 

Thank you.

 

 

Thanks for your quick response.

However my if then else statement returns boolean instead of values.

 

Formula as follows:

 

Local NumberVar NewVal;

 

if previous({L02DCS_GRN_Accrual_v6__Summary.APInvDtl.InvoiceNum}) = {L02DCS_GRN_Accrual_v6__Summary.APInvDtl.InvoiceNum} and
previous ({L02DCS_GRN_Accrual_v6__Summary.APInvDtl.InvoiceLine})={L02DCS_GRN_Accrual_v6__Summary.APInvDtl.InvoiceLine}

then newVal=0 else newVal={L02DCS_GRN_Accrual_v6__Summary.APInvDtl.ExtCost};

 

Do you know how to change it to display 0 if invoice number and line are duplicated and return invoice value if it relates to a unique invoice number and line.

 

 

Thanks indeed.

 

Novus