Beast Mode wrongly gives 0 as answer

My simple beast mode SUM(aprobado
) / SUM(ingreso_mesa
) returns 0 in all cases
Please help
Answers
-
Hi @Juan_Coronel_221b. Welcome to the Domo Community. You'll love it here.
You don't want to aggregate each column that goes into your beastmode when you are looking at line-by-line, as in your screenshot.Remove the SUM() that precedes each column, and that will give your 0 column values.
Like so:
aprobado
/ingreso_mesa
✅Did this solve your problem? Accept it as a solution!
❤️Did you love this answer? Mark it as "Awesome"!
👍Do you agree with this process? Click "Agree"!
0 -
Thanks a lot Devon, we try but it sends an error message
0 -
Make sure you wrap it in backticks :
` aprobado ` / ` ingreso_mesa `
✅Did this solve your problem? Accept it as a solution!
❤️Did you love this answer? Mark it as "Awesome"!
👍Do you agree with this process? Click "Agree"!
0 -
Hi Devon, we did try formatting it as
` aprobado ` / ` ingreso_mesa `
but it's still not producing the expected result
0 -
Actually, something strange happened. In our urgency to find a solution, we tried some unconventional options. One of those was to reverse the formula order, using:
SUM(ingreso_mesa) / SUM(aprobado)
While this is an incorrect calculation, it surprisingly produced a non-zero result
0 -
Can you share a screenshot of the card configuration as well?
0 -
Make sure you format the original calculation column as a percentage:
- click the column that has your intended calculation
- click format
- click display as Percentage
All of those values resolve to a number less than 1. The table will default to show 0, unless you tell it to treat it as a percentage
✅Did this solve your problem? Accept it as a solution!
❤️Did you love this answer? Mark it as "Awesome"!
👍Do you agree with this process? Click "Agree"!
1 -
I ggenovese
the beast modes are0 -
I Devon
let me show you we, try with that format0 -
Can you try giving the beat mode a different name, one that starts with a letter instead of a symbol? Also can you add a total row, does it give 0% as the total too?
0
Categories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 311 Workbench
- 7 Cloud Amplifier
- 9 Federated
- 3K Transform
- 114 SQL DataFlows
- 654 Datasets
- 2.2K Magic ETL
- 4.1K Visualize
- 2.5K Charting
- 803 Beast Mode
- 79 App Studio
- 44 Variables
- 758 Automate
- 188 Apps
- 480 APIs & Domo Developer
- 73 Workflows
- 17 DomoAI
- 40 Predict
- 17 Jupyter Workspaces
- 23 R & Python Tiles
- 408 Distribute
- 119 Domo Everywhere
- 279 Scheduled Reports
- 10 Software Integrations
- 141 Manage
- 137 Governance & Security
- 8 Domo Community Gallery
- 47 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 114 Community Announcements
- 4.8K Archive