Wrong Average Calculation in Beast Mode
sky00221155
⚪️
Hi,
I am trying to calculate the the average of my column which contains numbers from 17 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?
0
Best Answer

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!**0
Answers

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!
0
Categories
 10.7K All Categories
 1 APAC User Group
 12 Welcome
 36 Domo News
 9.6K Using Domo
 1.9K Dataflows
 2.4K Card Building
 2.2K Ideas Exchange
 1.2K Connectors
 339 Workbench
 252 Domo Best Practices
 11 Domo Certification
 461 Domo Developer
 47 Domo Everywhere
 101 Apps
 705 New to Domo
 84 Dojo
 Domopalooza
 1.1K 日本支部
 4 道場日本支部へようこそ
 23 お知らせ
 63 Kowaza
 297 仲間に相談
 649 ひらめき共有