Removing Zero from a Field 2

[nysouth]

I am trying to compare percentage of growth from one year to a next. If there is a value for this year, but not one for the last year the value is coming through as zero. To show the percentage of growth. This is against mathmatical law to divide by zero and the report crashes when it comes to a record that has the zero value. How can I remove these zeros?

Colleen

 

[kchaudhry]

You can create a formula like this:

if {table.denominatorfield}//replace with your fields
> 0
then
{table.numeratorfield}/{table.denominatorfield}//replace with your fields
else
0

Hope this helps!

Kchaudhry

 

[synapsevampire]

You may need to expand upon this to allow for nulls since you say it has nothing in there:

if not(isnull({table.denominatorfield}))
and
{table.denominatorfield} <> 0
then
{table.numeratorfield}/{table.denominatorfield}//replace with your fields
else
0

Note that I also changed it from being > 0 to <> 0 as you might have a negative number.

-k

 

[kchaudhry]

synapsevampire,

Thanks, your formula makes more sense.

Appreciate the correction

Kchaudhry

 

[nysouth]

Thanks to both of you. It worked great! - Colleen