Total Rows not Calculating
Best Answer

I found a solution to this issue. First  Huge shoutout to @DashboardDude who took time out of his busy schedule to meet with me and help me on my way to a solution.
To simplify, I had a beast mode similar to SUM(Priced Items) / SUM(Pounds Shipped). @DashboardDude noticed there were several beast modes like this but SUM(Pounds Shipped) would be a 0 value at times. The beast then became:CASE WHEN SUM(Pounds Shipped) = 0 THEN 0 ELSE SUM(Priced Items) / SUM(Pounds Shipped) END
So we fixed that part but still couldn't get totals in the total row for some reason.
Turns out if you have any NULL values in the column (in my case at least) DOMO isn't going to total those values. So the correct beast mode ended up looking like this:
CASE WHEN IFNULL(SUM(Pounds Shipped),0) = 0 THEN 0 ELSE SUM(Priced Items) / SUM(Pounds Shipped) END.
Thanks again to everyone, especially @DashboardDude, for your help
1
Answers

Double check that "Hide total" is not checked for those fields:
If I solved your problem, please select "yes" above
0 
@ColemenWilson Thanks for the reply. Those are unchecked but we still have the same issue. We also noticed this happening to our subtotals on another card…
0 
So are there values in the cells above for those fields?
If I solved your problem, please select "yes" above
0 
@ColemenWilson The green blocks contain data
0 
0

@Jarren trying to also help here. Just want to confirm that the columns are numeric. When you add columns to the top of analyzer where it says columns are they green or blue? A screenshot would help too.
John Le
You're only one dashboard away.
Click here for more video solutions:
0 
@DashboardDude I verified the fields are numeric, for the most part. Attached you'll find the screenshots you requested. Thank you in advance for your help
0 
@Jarren and can you share a screen shot of what Totals looks like under chart properties?
John Le
You're only one dashboard away.
Click here for more video solutions:
0 

@Jarren Thanks. Truthfully, this is a bit difficult to help without seeing context. I'm happy to give 30 min if you are free and willing to share your screen, but if not I hope you can figure out what's going on:
Feel free to book 30 for tomorrow if you want to:
John Le
You're only one dashboard away.
Click here for more video solutions:
0 
I found a solution to this issue. First  Huge shoutout to @DashboardDude who took time out of his busy schedule to meet with me and help me on my way to a solution.
To simplify, I had a beast mode similar to SUM(Priced Items) / SUM(Pounds Shipped). @DashboardDude noticed there were several beast modes like this but SUM(Pounds Shipped) would be a 0 value at times. The beast then became:CASE WHEN SUM(Pounds Shipped) = 0 THEN 0 ELSE SUM(Priced Items) / SUM(Pounds Shipped) END
So we fixed that part but still couldn't get totals in the total row for some reason.
Turns out if you have any NULL values in the column (in my case at least) DOMO isn't going to total those values. So the correct beast mode ended up looking like this:
CASE WHEN IFNULL(SUM(Pounds Shipped),0) = 0 THEN 0 ELSE SUM(Priced Items) / SUM(Pounds Shipped) END.
Thanks again to everyone, especially @DashboardDude, for your help
1 
@Jarren Glad you figured it out!!
John Le
You're only one dashboard away.
Click here for more video solutions:
0
Categories
 All Categories
 1.6K Product Ideas
 1.6K Ideas Exchange
 1.5K Connect
 1.2K Connectors
 286 Workbench
 4 Cloud Amplifier
 7 Federated
 2.8K Transform
 91 SQL DataFlows
 585 Datasets
 2.1K Magic ETL
 3.6K Visualize
 2.4K Charting
 651 Beast Mode
 37 App Studio
 33 Variables
 635 Automate
 162 Apps
 432 APIs & Domo Developer
 39 Workflows
 2 DomoAI
 31 Predict
 12 Jupyter Workspaces
 19 R & Python Tiles
 377 Distribute
 107 Domo Everywhere
 266 Scheduled Reports
 4 Software Integrations
 104 Manage
 101 Governance & Security
 6 Domo University
 21 Product Releases
 Community Forums
 39 Getting Started
 29 Community Member Introductions
 93 Community Announcements
 4.8K Archive