How can I write this formula in beast mode?

Liliana_Al_Zakout · 2025-04-02T17:19:40+00:00

There was an error rendering this rich post.

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!

Find more posts tagged with

Cards

Dashboard

Beast Mode

Accepted answers

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

All comments

Data_Devon

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