Wrong Average Calculation in Beast Mode

Options
sky00221155
sky00221155 Member
in Charting

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?

image.png


Best Answer

  • GrantSmith
    GrantSmith Coach
    Answer ✓
    Options

    Have you tried the AVG function? It ignores NULLs


    AVG(Score)

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**

Answers

  • GrantSmith
    GrantSmith Coach
    Answer ✓
    Options

    Have you tried the AVG function? It ignores NULLs


    AVG(Score)

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**
  • sky00221155
    sky00221155 Member
    Options

    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!

Categories