Skip to Content
avatar image
Former Member

I would like to know if it is possible to omit #DIV/0 rows when summarizing on a column

I am providing an average of the percents listed in a given column. However, some of the returns (as designed) are returning a #DIV/0 error. With that being the case, as we know with basic division... because we are essentially dividing by 0... this is the cause of the error-

So, I want to know, is it possible for me to write a statement that omits those values in WebI, from the overall Average... I'm thinking an If statement of some form...

I'm currently using:

=Average(Round([v1]/[v2]*100;0))+"%"

AND I'M USING THIS AT THE ROW LEVEL:

=If(IsError([v1]/[v2]))Then ""

ElseIf(IsNull(Round([v1]/[v2]*100;0))) Then ""

Else Round([v1]/[v2]*100;0)+"%"

Thoughts?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • May 08, 2017 at 09:02 PM

    Use iserror() function with if-else condition.

    =if(iserror(Average(Round([v1]/[v2]*100;0))+"%")) then "" else Average(Round([v1]/[v2]*100;0))+"%"

    Recheck your average formula.it seems it's not correct.you have used average() function and manually used v1/v2*100.

    Add comment
    10|10000 characters needed characters exceeded