Distinct count as total field

Meeting place for R&R customers and clients to share tips and ideas. Post your questions, messages or problems here.
Post Reply
Stephane_Plante_(Guest)
Posts: 2
Joined: Tue Oct 10, 2017 12:44 pm

Distinct count as total field

Post by Stephane_Plante_(Guest) » Mon Nov 12, 2001 2:51 pm

Hi,____I^m building a report on wich I need to have the number of invoices sent for each month and the number of distinct custumer to which I sent those invoices.____Is there a way to have theese results in R&R 8.1 (build 8.1.027)?____Thanks you very much for your fast answer!____Stephane Plante__splante@cia.ca

kfleming
Posts: 5795
Joined: Tue Oct 10, 2017 12:44 pm

=> RE: Distinct count as total field

Post by kfleming » Mon Nov 12, 2001 4:36 pm

Sort/group your report by__Month__Customer__Invoice____Then create two total fields. Both will reset by month but the first will accumulate once per Customer and the second will be once per invoice. You get to accumulation by clicking the Options button in the totals dialog.________Kathleen__R&R Support

Post Reply