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
 11K All Categories
 5 Private Company Board
 2 APAC User Group
 12 Welcome
 43 Domo News
 10K Using Domo
 2K Dataflows
 2.5K Card Building
 2.2K Ideas Exchange
 1.2K Connectors
 349 Workbench
 267 Domo Best Practices
 12 Domo Certification
 474 Domo Developer
 51 Domo Everywhere
 111 Apps
 728 New to Domo
 85 Dojo
 Domopalooza
 1.1K 日本支部
 4 道場日本支部へようこそ
 31 お知らせ
 65 Kowaza
 303 仲間に相談
 664 ひらめき共有