How can I write this formula in beast mode?

Liliana_Al_Zakout

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!

Data_Devon

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

Data_Devon

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