1 2 Previous Next 19 Replies Latest reply on Feb 18, 2016 4:57 PM by Bora Beran

    Nested IF statement using And/Or

    Christopher Lee
      x199.996
      x299.995
      x399.997
      x499.999
      if
      (([Hostname]='x1' or [Hostname]='x2') and [% Uptime (External)]>=99.9) 
      and
      (([Hostname]='x3' or [Hostname]='x4') and [% Uptime (External)]>=99.9)
      then 1
      ELSE 0 END
      

       

       

      What I'm attempting to do is compare x1 and x2 together, and make sure they are above 99.9. Then compare x3 and x4 together and make sure they are above 99.9. In tableau, this equation generates a 0. Why? Note that all of the values are above 99.9 anyway, so its very confusing. Can you help?

        1 2 Previous Next