Hello,

I'm farily new to K2 and i am in the progress of (trying to) developing an audit smartform for farms which contains a number of questions. For each question the farm will be awarded an 'Audit Score' of 0, 1, 2 or n/a if the question is not applicable.

For each question i have created a smartbox smartobject field for the Audit Acore.

To start with i want to perform what is essentially a SUMIF statment of all the Audit Score fields with a value of 2 listed and the same calculation but where the Audit Score fields contain a value of 1.

I would also like to perform a COUNTIF statement to record the number of times a value of 0 is recorded the in the Audit Score fields.

I am not sure if either are possible or if how i have set this up is the best way, so any advice would be much appreciated.

Thanks 

Marc