dividing by zero 1

[jschill2628]

Hello,

I am having a little trouble. I have sums in my report footers.
{#Precursor} and {#Serious}. I also have a formula in my report footer: {#Precursor}/{#Serious}.

the problem comes when my user chooses a time frame where there may be a zero count for the {#Serious), thus you are dividing by zero.

I tried to create the following formula:
if {#Serious} = 0 then "0" else
({#Precursor}/{#Serious})

but crystal highlights the second line, and tells me I need a string. Can someone smarter then me tell me what is wrong with my formula.

Thanks in advance!!!

 

[pmax9999]

Try:

If {#Serious} = 0
Then 0
Else ({#Precursor}/{#Serious})

or

If {#Serious} <> 0
Then ({#Precursor}/{#Serious})


Regards
Pete

 

[jschill2628]

that worked, thank you!!