Formula ??

[pungigi]

I need to return the Average of 2 fields, how do I do that in a formula if Both fields = 0???

Crystal Advanced 9.0

Formula:
if Sum ({@Ambulance Miles}) >=0
then Sum ({@Ambulance Miles})/Sum ({@Ambulance Trips})
else 0

Ambulance Miles =0
Ambulance Trips =0

Would like to return 0 but not sure how.

 

[Katy44]

Well if ambulance trips is zero then it's always going to cause problems:

if Sum ({@Ambulance Trips}) = 0 then 0 else
(if Sum ({@Ambulance Miles}) >=0
then Sum ({@Ambulance Miles})/Sum ({@Ambulance Trips})
else 0)

would work

 

[Katy44]

try:

if Sum ({@Ambulance Trips}) = 0 then 0 else
(if Sum ({@Ambulance Miles}) >=0
then Sum ({@Ambulance Miles})/Sum ({@Ambulance Trips})
else 0)

does this work?

 

[pungigi]

THANK YOU