4 Replies Latest reply: Jul 12, 2017 10:01 PM by Wai Meng Leong RSS

    Count of values (Greater than or lesser than)

    Wai Meng Leong

      Hi all,

       

      I have a field(TOTAL GOALS) which has values 1, 2, 3, 4, 5, 6, 7, ....

      How do I create in a simple table, a column which counts the number of times TOTAL GOALS is:

      >0.5,

      <0.5,

      >1.5,

      <1.5

       

      etc...

       

      Thanks in advance!

       

      Regards,

      Wai Meng