Dear community,
I want to create a new calculated field that is the average of 4 questions but saying Average = (A+B+C+D)/4 is wrong as sometimes we have missing values (people not responding to all questions).
How can we make an average of those 4 questions and taking into account the missing value?
Thanks in advance,
Leslie
Solved
Projects - Calculated field = average
Best answer by Marti
We created a separate field as we do something similar, but we have to account for a block of questions. We do this at the bottom of the survey.
Then in Embedded data we add these fields together and use that field name for the calculation
+13We created a separate field as we do something similar, but we have to account for a block of questions. We do this at the bottom of the survey.Then in Embedded data we add these fields together and use that field name for the calculation
Hi Marti,
Thanks for your reponse.
Based on that, what would be the calculated field to create if I want an average of "Responses by Dimension" but somehow I don't have any response for one of the created field (ex: ${e://Field/Care%20Dim%20Total)?
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.