Topics started by FDG2102 | XM Community

Topics started by FDG2102

1 Topic

F
FDG2102
asked in Survey Platform (Before March 2021)

How do I create a custom variable to create an average score?

I am trying to create a custom variable that creates an average score across item responses. I can set this up with a formula. The issue, however, is that the formula doesn't adjust depending on whether all of the items are answered by the responded. For example, I'm trying to create an average score for dimension A that is made up of items 1-5. The formula is item1 + 2 + 3 + 4 + 5 / 5. However, if a respondent fails to answer one item, the denominator should shift to 4. Is there a way to write the formulate to capture this dynamically?

0
R
Level 3 ●●●
3 years ago

Productivity playlist

Terms & Conditions