I have a SQL database I am trying to extract data from and place a conditional counting formula in it.
I am trying to count the instances of ID numbers in a table. Some of them can have two attributes associated with the ID numbers. I want to count each ID number for each attribute but I don't want to double count the ID number if it has both attributes associated with it.
By using the 'distinct count' in the running total field, you will count each ID# only once. Open up your crystal help and look up 'Running Total Fields' and it shoudl give you all the information that you need.