I have a survey template in SP integrated with InfoPath. There are 11 individual questions, all with yes and no radio buttons. I need a calculated field in SP for "percentage complete" to determine if the respondent has finished the survey. I have a calculated field called "survey status" that should work (see below). The issue I am having is the formula for the "percentage complete" calc field. I've tried COUNTA, IF, SUM with zero luck.
Survey Status: (=IF([Percentage Complete]=0,"Not Started",IF([Percentage Complete]=1,"Complete","In Progress"))
Percentage Complete: =COUNTA(Q1+Q2+Q3+Q4+Q5+Q6+Q7+Q8+Q9+Q10+Q11)/11
In InfoPath, the yes button is set for "True", the no button is set for "False". The above COUNTA formula works in Excel, however, no such luck in SP.
Any help or direction is greatly appreciated.