Welcome to the LimeSurvey Community Forum

Ask the community, share ideas, and connect with other LimeSurvey users!

Filter out NA answers for Average

  • michaelji
  • michaelji's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
6 years 8 months ago - 6 years 8 months ago #156701 by michaelji
Filter out NA answers for Average was created by michaelji
I have an Array question with four answers on a scale of 0, 1, 2, NA or 9.

How can I, just, average answers with the value of only 1 or 2. I was looking for an iff in (1,2) then answer, otherwise Null type of expression.

I do not want the 0 or 9/NA answers include on the average (I chose 9 for the NA answer since I had to us a number for the answer value.

This statement would be used in a Sum() expression, was my plan.

Your thoughts would be appreciated, thanks.
Last edit: 6 years 8 months ago by michaelji.
The topic has been locked.
  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
6 years 8 months ago #156713 by DenisChenu
Replied by DenisChenu on topic Filter out NA answers for Average

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
The following user(s) said Thank You: michaelji
The topic has been locked.

Lime-years ahead

Online-surveys for every purse and purpose