dividing zero by zero in a query, getting #error

[Tina S]

I wrote an expression to divide column 1 by column 2 to give me a monthly
result. and I am showing all 12 months, so column 2 is zero, until the end of
the months when the results are filled in. This is giving me a #error.

How can I make it return zero?

Hopefully I have given you enough info to answer my question. Thanks.

 

[david]

You need to replace each of the values with an expression,
like this:

column3: IIF(column2=0,0,column1/column2)

(david)

 

[Tina S]

I got it to work by doing this,

Field: Column3: IIf([Column2]<>0,([Column1]/[Column2]),0)
Made the Total: Expression.

Now the report footer that is summing these results is returning
"#Div/0!" and "#Num!". Now as the months go by, the data will fill in and
it should return the proper sums, but can this be fixed so the report looks
better?

 

[david]

What expression do you have in the report control that is returning
#div/0 ? You may wish to use an IIF expression there.

Also, you may like the result better using Null instead of zero.

Field: Column3: IIf([Column2]<>0,([Column1]/[Column2]),Null)

(david)

I got it to work by doing this,

Field: Column3: IIf([Column2]<>0,([Column1]/[Column2]),0)
Made the Total: Expression.

Now the report footer that is summing these results is returning
"#Div/0!" and "#Num!". Now as the months go by, the data will fill in and
it should return the proper sums, but can this be fixed so the report
looks
better?

You need to replace each of the values with an expression,
like this:

column3: IIF(column2=0,0,column1/column2)

(david)

 

[Tina S]

I do 3 things. the first 2 are not visible on the reoprt.

The first textbox is "=Sum([Column1])"
The second textbox is "=Sum([Column2)]
The third textbox that is visible and is returning "#Div/0!" and "#Num!" is
"=([SUMColumn1]/[SUMColumn2])"

What expression do you have in the report control that is returning
#div/0 ? You may wish to use an IIF expression there.

Also, you may like the result better using Null instead of zero.

Field: Column3: IIf([Column2]<>0,([Column1]/[Column2]),Null)

(david)

I got it to work by doing this,

Field: Column3: IIf([Column2]<>0,([Column1]/[Column2]),0)
Made the Total: Expression.

Now the report footer that is summing these results is returning
"#Div/0!" and "#Num!". Now as the months go by, the data will fill in and
it should return the proper sums, but can this be fixed so the report
looks
better?

You need to replace each of the values with an expression,
like this:

column3: IIF(column2=0,0,column1/column2)

(david)


I wrote an expression to divide column 1 by column 2 to give me a
monthly
result. and I am showing all 12 months, so column 2 is zero, until the
end
of
the months when the results are filled in. This is giving me a #error.

How can I make it return zero?

Hopefully I have given you enough info to answer my question. Thanks.

 

[Tina S]

I GOT IT TO WORK BY DOING,

=IIf([Name of Sum of Column2]<>0,([Name of Sum of Column1]/[Name of Sum of
Column2]),0

I do 3 things. the first 2 are not visible on the reoprt.

The first textbox is "=Sum([Column1])"
The second textbox is "=Sum([Column2)]
The third textbox that is visible and is returning "#Div/0!" and "#Num!" is
"=([SUMColumn1]/[SUMColumn2])"

What expression do you have in the report control that is returning
#div/0 ? You may wish to use an IIF expression there.

Also, you may like the result better using Null instead of zero.

Field: Column3: IIf([Column2]<>0,([Column1]/[Column2]),Null)

(david)

I got it to work by doing this,

Field: Column3: IIf([Column2]<>0,([Column1]/[Column2]),0)
Made the Total: Expression.

Now the report footer that is summing these results is returning
"#Div/0!" and "#Num!". Now as the months go by, the data will fill in and
it should return the proper sums, but can this be fixed so the report
looks
better?

:

You need to replace each of the values with an expression,
like this:

column3: IIF(column2=0,0,column1/column2)

(david)


I wrote an expression to divide column 1 by column 2 to give me a
monthly
result. and I am showing all 12 months, so column 2 is zero, until the
end
of
the months when the results are filled in. This is giving me a #error.

How can I make it return zero?

Hopefully I have given you enough info to answer my question. Thanks.

 

[david]

:~) Glad it's working
(david)

I GOT IT TO WORK BY DOING,

=IIf([Name of Sum of Column2]<>0,([Name of Sum of Column1]/[Name of Sum of
Column2]),0

I do 3 things. the first 2 are not visible on the reoprt.

The first textbox is "=Sum([Column1])"
The second textbox is "=Sum([Column2)]
The third textbox that is visible and is returning "#Div/0!" and "#Num!"
is
"=([SUMColumn1]/[SUMColumn2])"

What expression do you have in the report control that is returning
#div/0 ? You may wish to use an IIF expression there.

Also, you may like the result better using Null instead of zero.

Field: Column3: IIf([Column2]<>0,([Column1]/[Column2]),Null)

(david)

I got it to work by doing this,

Field: Column3: IIf([Column2]<>0,([Column1]/[Column2]),0)
Made the Total: Expression.

Now the report footer that is summing these results is returning
"#Div/0!" and "#Num!". Now as the months go by, the data will fill
in and
it should return the proper sums, but can this be fixed so the report
looks
better?

:

You need to replace each of the values with an expression,
like this:

column3: IIF(column2=0,0,column1/column2)

(david)


I wrote an expression to divide column 1 by column 2 to give me a
monthly
result. and I am showing all 12 months, so column 2 is zero, until
the
end
of
the months when the results are filled in. This is giving me a
#error.

How can I make it return zero?

Hopefully I have given you enough info to answer my question.
Thanks.

 

[Tina S]

Thanks for your time and help!

:~) Glad it's working
(david)

I GOT IT TO WORK BY DOING,

=IIf([Name of Sum of Column2]<>0,([Name of Sum of Column1]/[Name of Sum of
Column2]),0

I do 3 things. the first 2 are not visible on the reoprt.

The first textbox is "=Sum([Column1])"
The second textbox is "=Sum([Column2)]
The third textbox that is visible and is returning "#Div/0!" and "#Num!"
is
"=([SUMColumn1]/[SUMColumn2])"

:

What expression do you have in the report control that is returning
#div/0 ? You may wish to use an IIF expression there.

Also, you may like the result better using Null instead of zero.

Field: Column3: IIf([Column2]<>0,([Column1]/[Column2]),Null)

(david)

I got it to work by doing this,

Field: Column3: IIf([Column2]<>0,([Column1]/[Column2]),0)
Made the Total: Expression.

Now the report footer that is summing these results is returning
"#Div/0!" and "#Num!". Now as the months go by, the data will fill
in and
it should return the proper sums, but can this be fixed so the report
looks
better?

:

You need to replace each of the values with an expression,
like this:

column3: IIF(column2=0,0,column1/column2)

(david)


I wrote an expression to divide column 1 by column 2 to give me a
monthly
result. and I am showing all 12 months, so column 2 is zero, until
the
end
of
the months when the results are filled in. This is giving me a
#error.

How can I make it return zero?

Hopefully I have given you enough info to answer my question.
Thanks.