Beast Mode wrongly gives 0 as answer

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

Please help

Answers

  • Data_Devon
    Data_Devon Contributor

    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"!

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

  • Data_Devon
    Data_Devon Contributor

    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"!

  • Hi Devon, we did try formatting it as

    ` aprobado ` / ` ingreso_mesa `

    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?

  • Data_Devon
    Data_Devon Contributor

    Make sure you format the original calculation column as a percentage:

    1. click the column that has your intended calculation
    2. click format
    3. 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"!

  • I ggenovese

    the beast modes are

  • I Devon

    let me show you we, try with that format

  • 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?