How Domo calculate the average of a column
Hi,
In my data set, I have a column that has a score of 17. I want to use the average of this column. However, some of the rows in this column is blank. Is Domo just going to ignore these blank when calculate the average? Or I need to add anything in the blank rows to make the calculation accurate?
Best Answers

Hi @sky00221155
Domo will ignore those blanks when calculating the average. It depends on your use case and what a blank value represents. NULLs typically mean there is no data so there's no certainty as to what that value represents and is typically ignored when calculating averages. If you want the NULLs to represent something then you'd need to set the NULLs to be a specific value.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**2 
@sky00221155 the NULL handling on aggregate functions (like AVG) is the same as in Excel. If the column contains a NULL, it will not impact the numerator or denominator while calculating average. If, for your data, NULL is synonymous with 0, then you have to replace the NULLs with 0 and then they will impact the average.
Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"2
Answers

Hi @sky00221155
Domo will ignore those blanks when calculating the average. It depends on your use case and what a blank value represents. NULLs typically mean there is no data so there's no certainty as to what that value represents and is typically ignored when calculating averages. If you want the NULLs to represent something then you'd need to set the NULLs to be a specific value.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**2 
@sky00221155 the NULL handling on aggregate functions (like AVG) is the same as in Excel. If the column contains a NULL, it will not impact the numerator or denominator while calculating average. If, for your data, NULL is synonymous with 0, then you have to replace the NULLs with 0 and then they will impact the average.
Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"2 
Thank you! That helps a lot.
0
Categories
 All Categories
 1.8K Product Ideas
 1.8K Ideas Exchange
 1.5K Connect
 1.2K Connectors
 299 Workbench
 6 Cloud Amplifier
 8 Federated
 2.9K Transform
 100 SQL DataFlows
 616 Datasets
 2.2K Magic ETL
 3.8K Visualize
 2.5K Charting
 729 Beast Mode
 55 App Studio
 40 Variables
 682 Automate
 175 Apps
 451 APIs & Domo Developer
 46 Workflows
 10 DomoAI
 34 Predict
 14 Jupyter Workspaces
 20 R & Python Tiles
 394 Distribute
 113 Domo Everywhere
 275 Scheduled Reports
 6 Software Integrations
 121 Manage
 118 Governance & Security
 Domo Community Gallery
 38 Product Releases
 10 Domo University
 5.4K Community Forums
 40 Getting Started
 30 Community Member Introductions
 108 Community Announcements
 4.8K Archive