dividing by 0 in data when writing a formula

[enassif]

Crystal Report X
Data is from access file.
I am writing a formula for getting an average cost per unit.
Some of the units in the data equal 0(zero).
How do I get the formula to ignore all 0(zeros)

Thank you for your help

 

[bdreed35]

Use an If..Then..Else statement to test for 0:

if {table.fieldB} = 0
then 0
else {table.fieldA} / {table.fieldB}

~Brian

 

[enassif]

Thank you that worked!