Trying to count records with a value greater than 0
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!
Add this calculation field:
GetAsBoolean ( Field B ) + GetAsBoolean ( Field C ) + GetAsBoolean ( field D )