Division by Zero error

[mcbassman]

I am receiving a division by zero error in relation to the following:-

(Sum ({@Payments},{aps_group.code})/Sum ({@Invoice},{aps_group.code}))*100

It is strange, as the report was written some time ago and this error has only just appeared.

I am not particulary au fait with Crystal Reports, so a laymans response would be appreciated.

I am using Crystal Reports XI if that helps.

Thank you in advance.

BASS

[jggtz]

If Sum ({@Invoice},{aps_group.code})) <> 0 Then
    (Sum ({@Payments},{aps_group.code})/Sum ({@Invoice},{aps_group.code}))*100
Else
    0

[jnole]

If the result should equal 100% for no issues, simply force the formula to display 100 if Zero result.

If Sum ({@Invoice},{aps_group.code})) <> 0 Then
    (Sum ({@Payments},{aps_group.code})/Sum ({@Invoice},{aps_group.code}))*100
Else
    100