5 Replies Latest reply on Dec 12, 2013 10:24 AM by Matt Lutton

    Between calculated field?

    Kiran v

      Does anyone know how to create a calculated field with between, I am stumped. Any help would be appreciated.

       

      Trying to create a parameter based on this formula and analyze by color. I tried to do this

       

      if [capacity]> 300 then "Large"

      elseif [Capacity]>= 200 then "Medium"

      elseif [Capacity]>= 100 then "Small"

      else "none"

      end

       

      what i really want to see is :

       

      if capacity is between 50-150 then "small"

      elseif capacity is between 151-250 then "medium"

      elseif  250-300+ then "large"

      else "none"

      end

       

      Can i achieve this in tableau?

       

      Thanks much

      K