I am using the following formula to

[kchaudhry]

I am using the following formula to calcuate a summary field.

(Sum ({@LocalTransCurrentMonthT1}, {participant.id}) + Sum ({@OutTransCountCurrentMonthT1}, {participant.id}))/{@TotalProdCurrentMonthT1}*100

I get an error message as the value in the denominator is sometimes zero.

Can someone please guide me how to change the forumla so that I get a "0" in the field where the denominator is zero and perfrom regular division otherwise?

Thanks.

Kchaudhry

 

[bdreed35]

You need to check for 0 before performing the calc.

if {@TotalProdCurrentMonthT1} > 0 then
    (Sum ({@LocalTransCurrentMonthT1}, {participant.id}) +
     Sum ({@OutTransCountCurrentMonthT1}, {participant.id}))
     /{@TotalProdCurrentMonthT1}*100
else
   0 //or whatever the default value should be

~Brian

 

[kchaudhry]

Brian,

As always you have been a great help.

Thanks,

Kchaudhry