How to calculate a % of line value from the grand total inside a table in domo card
I am trying to find the percentage of the cost of sales from the total cost of sales. I have used the following calculation in beast mode.
(`Cost of Sales` / (SUM(`Cost of Sales`))
However, this calculation is not returning accurate values the lower cost of sales values have a higher percentage than the higher cost of sales values along with this calculation I have other measures/beast mode calculations from my data set inside my table and have changed their aggregation to a sum not sure if that would affect it but will attach a screenshot.
Best Answers

@Utz That makes sense. The reason your formula is not returning as expected is because it's only calculating using the total cost per seasonal value, not the grand total. You will need use a window function or a fixed function in your denominator in order to include rows for all seasonal values. For example:
sum(`Cost of Sales`)/sum(sum(`Cost of Sales`) fixed ())
1
Answers

Hi, Michelle, I am trying to sum everything up for seasonal so I don't have multiple lines of the same values for seasonal field and for those measures, I have a cost of sales field and I want to make a calculation that will give me the percentage of the cost of sales of off the grand total for the cost of sales.
0 
@Utz That makes sense. The reason your formula is not returning as expected is because it's only calculating using the total cost per seasonal value, not the grand total. You will need use a window function or a fixed function in your denominator in order to include rows for all seasonal values. For example:
sum(`Cost of Sales`)/sum(sum(`Cost of Sales`) fixed ())
1 
Thank you so much Michelle that did the trick appreciate your insight and the quick responses!
0
Categories
 All Categories
 1.5K Product Ideas
 1.5K Ideas Exchange
 1.4K Connect
 1.1K Connectors
 285 Workbench
 4 Cloud Amplifier
 5 Federated
 2.7K Transform
 91 SQL DataFlows
 576 Datasets
 2.1K Magic ETL
 3.5K Visualize
 2.4K Charting
 619 Beast Mode
 25 App Studio
 33 Variables
 609 Automate
 155 Apps
 421 APIs & Domo Developer
 31 Workflows
 2 DomoAI
 29 Predict
 12 Jupyter Workspaces
 17 R & Python Tiles
 372 Distribute
 103 Domo Everywhere
 266 Scheduled Reports
 3 Software Integrations
 100 Manage
 97 Governance & Security
 4 Domo University
 15 Product Releases
 Community Forums
 37 Getting Started
 28 Community Member Introductions
 91 Community Announcements
 4.8K Archive