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

ChrisGaffan

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

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   

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

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

Thank You.