Beast Mode wrongly gives 0 as answer

Juan_Coronel_221b · April 2

My simple beast mode SUM(aprobado) / SUM(ingreso_mesa) returns 0 in all cases

Please help

Data_Devon · April 2

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

Juan_Coronel_221b · April 2

Thanks a lot Devon, we try but it sends an error message

Data_Devon · April 2

Make sure you wrap it in backticks :

` aprobado ` / ` ingreso_mesa `

Juan_Coronel_221b · April 3

Hi Devon, we did try formatting it as

` aprobado ` / ` ingreso_mesa `

but it's still not producing the expected result

Juan_Coronel_221b · April 3

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

ggenovese · April 3

Hi @Juan_Coronel_221b

Can you share a screenshot of the card configuration as well?

Data_Devon · April 3

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

Juan_Coronel_221b · April 3

I ggenovese

the beast modes are

Juan_Coronel_221b · April 3

I Devon

let me show you we, try with that format

ggenovese · April 4

Hi @Juan_Coronel_221b

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?

Juan_Coronel_221b · April 7

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.

Juan_Coronel_221b · April 7

Juan_Coronel_221b · April 7

Beast Mode wrongly gives 0 as answer

Answers

Categories