last sale (or most recent sale) greater than zero

[rickm140]

I have developed a sales tax expiration report to keep track of a customer's tax exempt certificate. I now need to add a column where I show the date of the last invoice/sale greater than zero. The reason for this is because we do have invoices amount where the sale amount = $0.00. Does anyone have any suggestions as to how to get the last sale/invoice date greater than 0. I want to do this in case we should have another sales tax audit and I can show when the last sale was made to all customers. My report would look like the following:
Cust ID Customer Name Sales Tax ID Salesperson Expiration Date Last Invoice/Sale Date

 

[lbass]

Insert a group on custID and then create a formula {@saledt}:

If {sales.amt}<>0 then {sales.date}

Insert a maximum on this at the CustID group level or write a second formula:

Maximum({@saledt},{table.custID})

-LB