Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Problem With Totals

Status
Not open for further replies.

granny1

Technical User
Jun 24, 2001
24
US
I have a report that is doing a total on customer count by district, division. Within a district I have 2 locations with the exact same customer count. Crystal is including the first location but dropping the second with the same customer count. This is creating a big problem in my totals. Any idea on how to get the second value to be included in the total ?
 
Create a formula that if it's a customer account give a value of 1 then sum all the values

IF (Customer No) >1 Then
1 Else 0

then do a sum on all the 1 values.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top