division by zero error with whileprintingrecords function

[dz0k52]

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.

 

[synapsevampire]

Try:

WhilePrintingRecords;
if {@sum workorders} <> 0 then
numbervar sumhrs /{@sum workorders}
else
0

Presumably {@sum workorders} doesn't do any division, it's best to show underlying formulas as well.

-k

 

[dz0k52]

That worked great. Thanks a million.
Is there anyway to "order by" the results of the above formula? (Placed in a group footer)

 

[dz0k52]

Sorry, The second issue (Sort Order) is addressed in this post:

http://www.tek-tips.com/viewthread.cfm?qid=1257961&page=1