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

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

Tagged:

Best Answer

  • MichelleH
    MichelleH Coach
    Answer ✓

    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   
    

Answers

  • MichelleH
    MichelleH Coach
    Answer ✓

    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
    ChrisGaffan Member
    edited March 7

    @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.