AnsweredAssumed Answered

Trying to count records with a value greater than 0

Question asked by gremlin9297 on Dec 22, 2014
Latest reply on Dec 22, 2014 by philmodjunk

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!

Outcomes