3 Replies Latest reply on Jan 18, 2017 1:24 PM by ahmad.awad

    count field

    ahmad.awad

      Hi,

      I have the attached excel sheet

      every machine has a temp

      I created a field called temp status

      if([temp]) >= 20 then "high"

      ELSEIF ([temp]) > 10 then "Reporting med"

      ELSE  "low"

      END

       

       

      but after i did that, i was hoping to see how many machines are "high", "med" ,and "low" but I could not do that

      any help would be appreciated

       

      Thanks