How to set up a min/max equation in a Beast Mode?

ChrisGaffan · 2023-03-07T19:27:20+00:00

There was an error rendering this rich post.

I would like to setup a beast mode to calculate a fill % for contracted values, however I would not like it to show any values that went above 100%. I know in Excel it would be as easy as

=MIN(100,SUM())

How would I accomplish the same thing within Domo?

The two columns being run against each other are as seen below.

Total weight in lb's / Contract Weights

Find more posts tagged with

Beast Mode

Accepted answers

MichelleH

Hi @user058901 does this give you what you need?

case 
when total weight in lb's / Contract Weights > 1 then 1 
else total weight in lb's / Contract Weights 
end

All comments

MichelleH

Hi @user058901 does this give you what you need?

case 
when total weight in lb's / Contract Weights > 1 then 1 
else total weight in lb's / Contract Weights 
end

ChrisGaffan

@MichelleH Yes, I just needed to add SUM before the equation and it worked perfectly. CASE

CASE
WHEN SUM(Total weight in lb's / Contract Weight) > 1 then 1
ELSE SUM(Total weight in lb's / Contract Weight)
END

Thank You.