Crystal Formula Grand Total - Running total 1

You will need to use a variable to achieve this. As long as the {AR_Customer.SalespersonNo} Group level results are working, something like this should work:

Place the following fomula in the Group Footer for the group on {AR_Customer.SalespersonNo}:

[Code {@Calculate}]
WhilePrintingRecords;

Global NumberVar AllCust;
Global NumberVar NoSale;

AllCust := AllCust + DistinctCount({AR_Customer.CustomerNo}, {AR_Customer.SalespersonNo});

NoSale := NoSale + {#CustomerCountNoYTDSales};

''
[/Code]

In the Report Footer Place the following Formula:

[Code {@Result}]
WhilePrintingRecords;

Global NumberVar AllCust;
Global NumberVar NoSale;

AllCust - NoSale
[/Code]

Hope this helps.

Cheers
Pete.

Thank you so much!!