Wednesday, March 7, 2012

Cannot Summerize a formula

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

No comments:

Post a Comment