1 Reply Latest reply on Jan 30, 2013 6:28 AM by Shawn Wallwork

    embed min formula inside max formula

    Miles Hunter

      I'm trying to embed a min formula inside a max formula. This is a calculation that I often use in excel - the ratio that I'm trying to calculate slides between 38.5% and 60.5%, when the ratio of [Losses]/[Premium] moves between 54% and 32%.

       

      max(38.5%,(min(60.5%,(54%-[Losses]/[Premium])+38.5%))

       

      How do I make this work in Tableau?

       

      Thanks,
      Miles