I am using Crystal 8.5 with an Oracle 10 database.
I have looked at many threads and cannot figure this one out. I have a formula:
WhilePrintingRecords;
numbervar sumhrs/({@sum workorders});
that is placed in the group footer to give me an average of records from another formula. It works great except sometimes the result of {@sum workorders} is zero and I get the "division by zero" error. I have tried
if {@sum workorders} = 0
then 0 else WhilePrintingRecords;
numbervar sumhrs/({@sum workorders});
But I get the same result. I would be happy with a zero as a result or text saying "NO Data" or even a blank feild if
{@sum workorders}) was a zero but I can't get rid of the error. Any help would be appreciated.
I have looked at many threads and cannot figure this one out. I have a formula:
WhilePrintingRecords;
numbervar sumhrs/({@sum workorders});
that is placed in the group footer to give me an average of records from another formula. It works great except sometimes the result of {@sum workorders} is zero and I get the "division by zero" error. I have tried
if {@sum workorders} = 0
then 0 else WhilePrintingRecords;
numbervar sumhrs/({@sum workorders});
But I get the same result. I would be happy with a zero as a result or text saying "NO Data" or even a blank feild if
{@sum workorders}) was a zero but I can't get rid of the error. Any help would be appreciated.