Exclude data formula help

[jlr123]

Data in report: customer no, invoice no, item,$ amt

I need formula to retrieve all customer no, invoice no, item code and $amount if there is no item code contained in the invoice = "Delivery"
I have tried using Item Code<> "Delivery" but it is not giving me the correct data.

 

[lbass]

I’m guessing that there are multiple records for the same invoice and that you wrongly want to show invoices with no delivery codes. You should have a group on invoice number. Then create a formula {@delivery} in the field explorer->formula editor:

//{@delivery}:
If ucase({table.itemcode})=“DELIVERY” then 1

Then go to report->selection formula->GROUP and enter:

sum({@Delivery},{table.invoiceno})=0

If you want to perform any summaries across invoices (e.g., sum of the amounts of all undelivered invoices), you would need to use running totals, since non-group-selected records are still “in” the report and would be included in the usual inserted summaries.

-LB