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
Best answer by Marti
View original