I have a table whose records contain at least 3 fields... Field1, Field2 and Field3.
I'd like to loop through the table and add up all the instances when the above 3 fields are positive values.
Example... if Field1 and Field2 contain a 5 and Field3 contains a 0 in all 7 records the total would be 14.
My current statement:
when Field1 > 0 then 1
when Field2 > 0 then 1
when Field3 > 0 then 1
My current statement returns 1 if any field is positive... thus the 7 records above would return 7 instead of 14.
Thank you for the help.