My simple beast mode SUM(aprobado) / SUM(ingreso_mesa) returns 0 in all cases
aprobado
ingreso_mesa
Please help
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
Thanks a lot Devon, we try but it sends an error message
Make sure you wrap it in backticks :
` aprobado ` / ` ingreso_mesa `
Hi Devon, we did try formatting it as
but it's still not producing the expected result
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
Hi @Juan_Coronel_221b
Can you share a screenshot of the card configuration as well?
Make sure you format the original calculation column as a 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
I ggenovese the beast modes are
I Devon let me show you we, try with that format
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?
Hi
Just wanted to give you all an update on this card
We found a fix that seems to be working
Here's the Beast Mode fix we put in:
CAST (SUM(`aprobado`) AS DECIMAL ) / CAST (SUM(NULLIF(`ingreso_mesa`,0)) AS DECIMAL)
The cards look like they're working now, but we want to keep an eye on them for the next days to make sure everything's good.