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.1K Product Ideas
 1.1K Ideas Exchange
 1.2K Connect
 966 Connectors
 254 Workbench
 Cloud Amplifier
 1 Federated
 2.4K Transform
 75 SQL DataFlows
 499 Datasets
 1.8K Magic ETL
 2.7K Visualize
 2.2K Charting
 360 Beast Mode
 19 Variables
 483 Automate
 101 Apps
 378 APIs & Domo Developer
 6 Workflows
 22 Predict
 6 Jupyter Workspaces
 16 R & Python Tiles
 316 Distribute
 64 Domo Everywhere
 252 Scheduled Reports
 59 Manage
 59 Governance & Security
 1 Product Release Questions
 5K Community Forums
 37 Getting Started
 23 Community Member Introductions
 63 Community Announcements
 4.8K Archive