Total row sum % instead of doing the % calculation
Hi,
I use one beastmode to give me the MTD % of achievement vs the MTD Target.
On one card it work with this rule :
sum(`product_A`)/(SUM(DISTINCT `product_a_Target_dly`)*DAY(CURDATE()))
So it's giving me the MTD % even in the total row.
I use the same formula on another card but with product_B.... and the total row show me a sum of all the percentage instead of doing the calculation.
I don't find what I'm doing bad.... is there a way for the total row to apply the calculation and not summing it ?
PS : If i put over () at the end... it work but then the % if wrong for all the store. Only the total row become good.
Thanks :)
Comments

Hi @Adrien
the total row is calculated on the card after the beast mode is calculated so it’s adding your percentages instead of calculating your total percentage.
if you want a total row you need to use an ETL to group your data together and sum all your columns using a group by tile then using an add constant tile put the value of total in your label field then append this row to your original dataset. Now your beast mode will work for the “total” row without telling your card to do the total row on it (it’s now included in your dataset)
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**2 
oh I see !
Will do that :)
Thank you !
0 
@Adrien most days of the week if you're doing SUM(DISTINCT) you've designed your data ... poorly. usually this happens b/c people JOIN their Actuals to Daily_Forecast and then use SUM(DISTINCT) to avoid double counting targets.
Don't. UNION your datasets.
If you continue the road you're on, if you had two separate products with different daily forecast OR if you had the same forecast across two days, you'd misrepresent your forecast.
https://www.youtube.com/watch?v=PVbOeLSae9o&t=252s consider this alternative.
Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0 
Oh great video !! I have taken a lot of notes haha
Thanks a lot !
0
Categories
 All Categories
 1.7K Product Ideas
 1.7K Ideas Exchange
 1.5K Connect
 1.2K Connectors
 292 Workbench
 4 Cloud Amplifier
 8 Federated
 2.8K Transform
 95 SQL DataFlows
 601 Datasets
 2.1K Magic ETL
 3.7K Visualize
 2.4K Charting
 689 Beast Mode
 43 App Studio
 39 Variables
 658 Automate
 170 Apps
 441 APIs & Domo Developer
 42 Workflows
 5 DomoAI
 32 Predict
 12 Jupyter Workspaces
 20 R & Python Tiles
 385 Distribute
 110 Domo Everywhere
 269 Scheduled Reports
 6 Software Integrations
 112 Manage
 109 Governance & Security
 8 Domo University
 25 Product Releases
 Community Forums
 39 Getting Started
 29 Community Member Introductions
 98 Community Announcements
 Domo Community Gallery
 4.8K Archive