Value 0 gives percentage error

[Monkey820]

If the {table.GOOD_PTS} value is 0, I get a "Division by zero" error. What formula should I use to consider this possiblity? I want to see a percentage but there will be some values of 0 in the report and, of course, I do not need to calculate them. But the other values in the report will need to have the calculation.

{table.MISSING_PTS}/Sum ({table.GOOD_PTS}

Micky
CRW8.5

 

[synapsevampire]

Try:

if Sum ({table.GOOD_PTS} = 0 then
0
else
{table.MISSING_PTS}/Sum ({table.GOOD_PTS}

-k

 

[synapsevampire]

Ooops, you had a typo and I copied:

if Sum ({table.GOOD_PTS}) = 0 then
0
else
{table.MISSING_PTS}/Sum ({table.GOOD_PTS})

-k

 

[synapsevampire]

And I think it should be:...

if Sum ({table.GOOD_PTS}) = 0 then
0
else
({table.MISSING_PTS}/Sum ({table.GOOD_PTS}))*100

-k

 

[Monkey820]

Absolutely Perfect!

Thank you!