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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment