Perhaps I've been looking at this too long, too hard. I know the solution must be simple. I'm working in Crystal 8.0.
I created 3 formulas to calculate the datediff between start and completion of 3 separate processes (and returned in days format)and placed in the report.
What I need to do now is add the results of the three columns representing the total number of days that were returned (some are blank, as the process never occurred)into a "Totals" column.
To me the formula seems simple but no data is returned in the Total column at all. Is it possible that the reason is because some of the results of my initial formulas are blank?
An example of the formula(s) I wrote to calculate the number of days is:
DateDiff ("d",{bankruptcy.date_filed}, {bankruptcy.released_date}).
If that is the reason why it will not add the columns, how can I get around this? (somehow creating an If statement to return a zero for number of days? If so, need help with that also).
Thanks so much for any and all help!
Lisa
I created 3 formulas to calculate the datediff between start and completion of 3 separate processes (and returned in days format)and placed in the report.
What I need to do now is add the results of the three columns representing the total number of days that were returned (some are blank, as the process never occurred)into a "Totals" column.
To me the formula seems simple but no data is returned in the Total column at all. Is it possible that the reason is because some of the results of my initial formulas are blank?
An example of the formula(s) I wrote to calculate the number of days is:
DateDiff ("d",{bankruptcy.date_filed}, {bankruptcy.released_date}).
If that is the reason why it will not add the columns, how can I get around this? (somehow creating an If statement to return a zero for number of days? If so, need help with that also).
Thanks so much for any and all help!
Lisa