Return a count of fields that dont have a null value

SeanNagy1

I want to have a field that returns a count from 6 different fields based on if there is a value or not. Basically i have a report that has the possibility of collecting field data at 6 different locations but they dont always need to all be used. The field should calculate the number of testing areas based on if the test area name is complete and add them up. This isnt in a repeat so not sure if the count function would work.

fklotz

You can see if a question has a value with the string-length() function.  For each question, if it has a string-length() that is greater than zero, return a 1, else return a zero.  Sum the values returned.

For this example survey:

if(string-length(${TestArea1}) > 0, 1, 0) 
+ if(string-length(${TestArea2}) > 0, 1, 0) 
+ if(string-length(${TestArea3}) > 0, 1, 0) 
+ if(string-length(${TestArea4}) > 0, 1, 0) 
+ if(string-length(${TestArea5}) > 0, 1, 0) 
+ if(string-length(${TestArea6}) > 0, 1, 0)