Grand Total summing the percentage instead of calculating
Every time we bring in any kind of calculated difference to the table, we get a grand total that sums up all the percentages.
For instance, for this Table, the rightmost column is calculating the difference between the two left columns. Every row is correct except for the Grand Total which sums up the percentage together rather than calculating the difference between the left two columns. We see the Grand Total difference for this sample dataset is 139.06% but in reality, the number should be 9%.
Can Domo implement a way to calculate the Grand Total instead of summing all the rows?
Comments

you'll need to aggregate the data in the beastmode when calculating the variance like below
(sum(
Column
)  sum(Column 1
)) / sum(Column 1
) *100I suspect you may just be doing
(
ColumnColumn 1
) /Column 1
*1003
Categories
 All Categories
 1.5K Product Ideas
 1.5K Ideas Exchange
 1.4K Connect
 1.1K Connectors
 284 Workbench
 4 Cloud Amplifier
 4 Federated
 2.7K Transform
 90 SQL DataFlows
 570 Datasets
 2K Magic ETL
 3.4K Visualize
 2.4K Charting
 604 Beast Mode
 17 App Studio
 29 Variables
 602 Automate
 152 Apps
 419 APIs & Domo Developer
 29 Workflows
 2 DomoAI
 28 Predict
 12 Jupyter Workspaces
 16 R & Python Tiles
 366 Distribute
 100 Domo Everywhere
 264 Scheduled Reports
 2 Software Integrations
 98 Manage
 95 Governance & Security
 15 Product Releases
 Community Forums
 37 Getting Started
 28 Community Member Introductions
 90 Community Announcements
 4.8K Archive