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.7K Product Ideas
 1.7K Ideas Exchange
 1.5K Connect
 1.2K Connectors
 295 Workbench
 6 Cloud Amplifier
 8 Federated
 2.8K Transform
 97 SQL DataFlows
 608 Datasets
 2.1K Magic ETL
 3.8K Visualize
 2.4K Charting
 710 Beast Mode
 50 App Studio
 39 Variables
 668 Automate
 170 Apps
 446 APIs & Domo Developer
 45 Workflows
 7 DomoAI
 33 Predict
 13 Jupyter Workspaces
 20 R & Python Tiles
 391 Distribute
 111 Domo Everywhere
 274 Scheduled Reports
 6 Software Integrations
 116 Manage
 113 Governance & Security
 Domo Community Gallery
 31 Product Releases
 9 Domo University
 5.3K Community Forums
 40 Getting Started
 30 Community Member Introductions
 103 Community Announcements
 4.8K Archive