Beast Mode

Beast Mode

How can I write this formula in beast mode?

Hello, I am trying to write this formula from google sheets in Beast Mode DOMO but I can't get to make it work. Does anyone know how to write it correctly in beast mode? Take into consideration that Year and Tons are columns.

(SUM(IF(Year = 2025, Tons,0))/(SUM(IF(Year = 2024, Tons,0))))-1

Thanks for your time in advance!

Best Answer

  • Contributor
    Answer ✓

    Hi @Liliana_Al_Zakout! Welcome to the community. I trust you'll find tremendous value in the collective brilliance of this group.

    Here's how you can replicate that in Beastmodes:


    SUM(CASE WHEN Year = '2025' THEN Tons ELSE 0 END)

    /

    SUM(CASE WHEN Year = '2024' THEN Tons ELSE 0 END)) - 1

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

Answers

  • Contributor
    Answer ✓

    Hi @Liliana_Al_Zakout! Welcome to the community. I trust you'll find tremendous value in the collective brilliance of this group.

    Here's how you can replicate that in Beastmodes:


    SUM(CASE WHEN Year = '2025' THEN Tons ELSE 0 END)

    /

    SUM(CASE WHEN Year = '2024' THEN Tons ELSE 0 END)) - 1

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

Welcome!

It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
Sign In