Looking for advice to divide time by procedure count 1

[mvalley]

I am trying to place the average time for a procedure on a Crystal report by using a formula.

I need to take the field total minutes divided by total cases performed. I tried the below formula ({proc_surg_dur.ps_total_minutes}/{proc_surg_dur.ps_performed}) but get the error message when I place it in the report “Division by Zero” How is the best way for me to obtain my objective?

 

[briangriffin]

if {proc_surg_dur.ps_performed} = 0 then 0

else

({proc_surg_dur.ps_total_minutes}/{proc_surg_dur.ps_performed})