3 Replies Latest reply on Jun 29, 2016 7:14 PM by Shinichiro Murakami

    IF statement help

    Mikey Michaels
    Mikey Michaels Jun 28, 2016 6:07 PM

      Hello All,

      I hope this message finds you all well.

      I'm in need of some help. Here is what I'm trying to accomplish:

       

      I'm trying to write an IF statement that will look at each category in my graph (License, ME&S, and Trial) and IF all categories for the Zone are above 60% THEN "Above Benchmark". IF <60% or blank then "Under Benchmark".

       

      So on the attached, the only zone that meets this criteria is GSF

       

       

      I'm struggling as I do not think the following is the best way to solve...."IF Category = "Trial" and EASy Utilization > .60 and Category - "ME&S" and EASy Utilization > .60......there has to be a better way!

       

      Thanks for your time.

       

      Regards,

      Mikey