Incorrect subtotals on the cards
Hi There,
I have this table on a card in Domo where the Average Wage = Labor Cost / Labor Hrs. The Avg wage is being calculated correctly in all the top 8 rows but in the subtotal row (highlighted in green at bottom) Avg Wage is being calculated as sum of all row's average wage, instead I would like to view it as 467137.17/26287.36 = $ 17.77 instead of $142.54
Is it possible to update it on the card for subtotals in chart properties?
Thanks in advance!
Best Answer

@Dev_ Subtotals of ratio calculations can show an unexpected result if the beast mode does not specify the aggregation. So, if your beast mode is
Labor Cost / Labor Hrs
it is calculating the ratio for each row individually and the subtotal aggregates the results. If you want your subtotal to represent the ratio of the other columns' subtotals, then you will need to aggregate each component individually within your beast mode like this:SUM(Labor Cost) / SUM(Labor Hrs)
2
Answers

This should be achievable. What is your Beast Mode formula right now?
Was this comment helpful? Click Agree or Like below.
Did this comment solve your problem? Accept it as the solution!0 
@Dev_ Subtotals of ratio calculations can show an unexpected result if the beast mode does not specify the aggregation. So, if your beast mode is
Labor Cost / Labor Hrs
it is calculating the ratio for each row individually and the subtotal aggregates the results. If you want your subtotal to represent the ratio of the other columns' subtotals, then you will need to aggregate each component individually within your beast mode like this:SUM(Labor Cost) / SUM(Labor Hrs)
2 
@MichelleH I was missing the SUM in my beast mode. Corrected it and it works!!! . Thank you so much.
0
Categories
 All Categories
 1.6K Product Ideas
 1.6K Ideas Exchange
 1.5K Connect
 1.2K Connectors
 288 Workbench
 4 Cloud Amplifier
 8 Federated
 2.8K Transform
 94 SQL DataFlows
 594 Datasets
 2.1K Magic ETL
 3.6K Visualize
 2.4K Charting
 670 Beast Mode
 42 App Studio
 34 Variables
 645 Automate
 165 Apps
 434 APIs & Domo Developer
 42 Workflows
 4 DomoAI
 31 Predict
 12 Jupyter Workspaces
 19 R & Python Tiles
 378 Distribute
 107 Domo Everywhere
 266 Scheduled Reports
 5 Software Integrations
 110 Manage
 107 Governance & Security
 8 Domo University
 23 Product Releases
 Community Forums
 39 Getting Started
 29 Community Member Introductions
 95 Community Announcements
 4.8K Archive