Hi
I have a report that has 2 levels of grouping
Group 1 - Date
Group 2 - Customer Ref
This shows for every month how many customers contacted me
I then insert a simple if then formula within the Group 2 line returning me back 1 or 0 if a condition is met.
The problem is, I cannot then sum all the 1's
I will be grateful for any helpInstead of using the formulas and trying to count them you could use a running total that is evaluated whenever the condition is met. In Crystal Reports (http://www.saveonsupport.com) this can be achieved using the formula button in the evaluate on section of the running total.|||Hi
r u sure that the 0 & 1 is in a numeric format, when it is in character format it will not allow to add,
type cast it using 'cDbl' and summerize
Showing posts with label contacted. Show all posts
Showing posts with label contacted. Show all posts
Subscribe to:
Posts (Atom)