Division by zero????????? 1

[Durango122]

Hi All
cr 9.0
ms sql

i have this group terri
900 and 600 are sum(current value,terri1)
here are my value
territory Id territory Name current prior % change
E01 PC-E01 900 600

and have this formula
if
sum({@Prior_Contribution},{TRANSACTION_HISTORY.TERR1}) = 0
then
0
else
100-(sum({@Prior_Contribution},{TRANSACTION_HISTORY.TERR1})/sum({@Current_Contribution},{TRANSACTION_HISTORY.TERR1})*100)

i get error division by 0
i check to make sure that the prior as a value = 0
what could be the problem????????????
thanks


Durango122
if it moves and should not used Duck Tape
if does not move and should used WD-40

 

[synapsevampire]

This is zero:

sum({@Current_Contribution},{TRANSACTION_HISTORY.TERR1})

Change the formula to:

if
sum({@Current_Contribution},{TRANSACTION_HISTORY.TERR1} = 0
then
0
else
100-(sum({@Prior_Contribution},{TRANSACTION_HISTORY.TERR1})/sum({@Current_Contribution},{TRANSACTION_HISTORY.TERR1})*100)

-k