Wrong Average Calculation in Beast Mode
Options

sky00221155
Member
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?
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
-
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 -
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
- All Categories
- Product Ideas
- 2.1K Ideas Exchange
- Data Connections
- 1.3K Connectors
- 309 Workbench
- 17 Cloud Integrations
- Data & ETL
- 2.3K Magic ETL
- 120 SQL DataFlows
- 666 Datasets
- Visualize & Apps
- 90 App Studio
- 198 Pro-code Components
- 2.6K Charting & Analyzer
- 873 Calculations & Variables (Beast Mode)
- AI & Data science
- 23 Domo AI & AI Chat
- 4 Managing AI
- 18 Jupyter Workspaces
- Automate
- 122 Workflows
- Alerts
- Distribute
- 118 Domo Everywhere
- 284 Reporting
- Manage
- 145 Governance & Security
- 489 APIs
- 11 Add-ins & Plugins
- 13 Domo Community Gallery
- 49 Product Releases
- 13 Domo University
- Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 118 Community Announcements
- 5K Archive