Crystal Formula Grand Total - Running total
Crystal Formula Grand Total - Running total
(OP)
I have this formula in a report which I need a Grand Total
DistinctCount ({AR_Customer.CustomerNo}, {AR_Customer.SalespersonNo}) - {#CustomerCountNoYTDSales} (this last part is a running total formula: Sum ({@YTD}, {AR_Customer.CustomerNo})=0
What I am trying to get is a Grand Total of Distinct CustomerNo minus Distinct CustomerNo which have No YTD sales (which will be number of Revenue Customers)
Hopefully, you can assist me. Thanks!
DistinctCount ({AR_Customer.CustomerNo}, {AR_Customer.SalespersonNo}) - {#CustomerCountNoYTDSales} (this last part is a running total formula: Sum ({@YTD}, {AR_Customer.CustomerNo})=0
What I am trying to get is a Grand Total of Distinct CustomerNo minus Distinct CustomerNo which have No YTD sales (which will be number of Revenue Customers)
Hopefully, you can assist me. Thanks!
RE: Crystal Formula Grand Total - Running total
Place the following fomula in the Group Footer for the group on {AR_Customer.SalespersonNo}:
CODE --> {@Calculate}
In the Report Footer Place the following Formula:
CODE --> {@Result}
Hope this helps.
Cheers
Pete.
RE: Crystal Formula Grand Total - Running total