Using Total as figure in Beast calc
This might be obvious, but I couldn't find how to do this. Is it possible to use the total figure (row total) as an individual figure in beast mode calcs? I have tried to do the following calc:
Amount/SUM(Amount)
The above calc is only doing the calculation on a row by row basis and is not using the sum figure/total figure.
Best Answer

You're not able to do this at the card level and would need to calculate this at within your ETL/Data Transform process.
Calculations at the card level are viewed "rowbyrow" so if your calculation is comparing Amount in Row 1, a SUM(Amount) would only return the amount of Row 1 at Row 1 since it's not grouped and still broken out by each row.
An alternative would be to calculate the SUM(Amount) ahead of time and add it as a constant value column to your dataset. This would let you do Amount / (Precalculated SUM(Amount)) for each row.
Let me know if you have any other questions,
Valiant_Ronin
**Please mark "Accept as Solution" if this post solves your problem
**Say "Thanks" by clicking the "heart" in the post that helped you.0
Categories
 10.7K All Categories
 13 Getting Started in the Community
 41 Beastmode & Analytics
 2.1K Data Platform & Data Science
 59 Domo Everywhere
 2.7K Charting
 2.5K Ideas Exchange
 1.3K Connectors
 362 Workbench
 303 Use Cases & Best Practices
 503 APIs
 120 Apps
 48 News
 753 Onboarding
 1.2K 日本支部
 Private Company Board