Wrong Average Calculation in Beast Mode

sky00221155 · 2021-07-26T22:04:21+00:00

There was an error rendering this rich post.

Hi,

I am trying to calculate the the average of my column which contains numbers from 1-7 and some blanks. I thought the Beast Mode ignore the blank cell when doing the calculation. However, it seems like it still include the blank cell in the Denominator. Below is the example, where the average should be 5.73 but the result is 5.45.

Is there a way it will ignore the blank cell?

Find more posts tagged with

Accepted answers

GrantSmith

Have you tried the AVG function? It ignores NULLs

AVG(Score)

All comments

GrantSmith

Have you tried the AVG function? It ignores NULLs

AVG(Score)

sky00221155

Yes, I try the AVG function. It was showing the wrong result at first, however, after clean up some cells, the AVG function actually works now. Thank you so much for the help!

Quick Links

All Categories
Recent Posts
Activity
Unanswered
Groups
Best Of