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

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

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