Projects - Calculated field = average | XM Community
Skip to main content
Solved

Projects - Calculated field = average

  • January 19, 2021
  • 2 replies
  • 20 views
L

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

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.
image.pngThen in Embedded data we add these fields together and use that field name for the calculation
image.png

    2 replies

    Marti
    QPN Level 2 ●●
    Forum|alt.badge.img+13
    • Marti
    • QPN Level 2 ●●
    • Answer
    • January 19, 2021

    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.
    image.pngThen in Embedded data we add these fields together and use that field name for the calculation
    image.png

    L
    • LeslieB
    • Author
    • January 26, 2021

    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)?

    Terms & ConditionsAccessibility statement