1 Reply Latest reply on Dec 22, 2014 1:33 PM by philmodjunk

    Trying to count records with a value greater than 0

    gremlin9297

      Title

      Trying to count records with a value greater than 0

      Post

      So im not sure if im going to explain this well but here it goes. 

      Field A        Field B        Field C      Field D

      Record 1         0                  1               0

      Record 2         1                  1               0

      Record 3         0                  0               0

       

      What I would like to do is show a count of how many times each record has a value greater than 0 in the other fields so a result looking something like this

       

      Field A        Count

      Record 1        1

      Record 2        2 

      Record 3        0

       

      Any help would be appreciated thank you!