Anyone know how to get rid of #DIV/0 in a result?

building reports webintelligence
1

nm

farmcock (BOB member since 2008-01-15)

2

Something like:-

=Sum(If(Isnull([Field]);0;[Field]))

Mak 1 :uk: (BOB member since 2005-01-06)

3

Or …

=If([Divisor]=0;0;[Numerator]/[Divisor])

That manner of kidney.

Damocles :uk: (BOB member since 2006-10-05)

4

Thanks guys, but i tried both and neither worked - still get #DIV/0

farmcock (BOB member since 2008-01-15)

5

You’ll have to give us more info :).

If you had nulls, mine would have worked, if you had 0s Damocles formulae would have worked, so…

What have you got in the way of data?

What exactly you are tring to do and any formulae used…

Mak 1 :uk: (BOB member since 2005-01-06)

6

I’m using:

Formula:

[Closed Files] / ([Total New Files]+[Assigned Files]) = ‘X’

Actual Data:

1 / 0 = ‘X’

Result:

#DIV/0 = ‘X’

farmcock (BOB member since 2008-01-15)

7

I had the Numerator & Divisor backwards when I attempted the recommended correction - it works now.

Thanks to you both!

farmcock (BOB member since 2008-01-15)

8

Perhaps I should have used the word ‘Denominator’.

Damocles :uk: (BOB member since 2006-10-05)

9

You could have used IsError() function too.

Jansi :india: (BOB member since 2008-05-12)