Welcome to the LimeSurvey Community Forum

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

Can I make some calculation and display them based on the answer received

  • c1v3ssss
  • c1v3ssss's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
5 years 2 months ago #179017 by c1v3ssss
Hello,

I have a 30 questions survey, and the answers are a scale from 1 to 5.

Based on the results, I want to make some calculations, I want to show for each participant once they submitted the survey. These are the formulas I would have used in Excel for example AVERAGE(q2:q10,q28) and AVERAGE(q3,q11:q20,q28)

Is this possible, any suggestions?

Thanks
The topic has been locked.
  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
5 years 2 months ago #179019 by DenisChenu
Hi,

No average in Expression, but you can easily use this
Code:
{if(count(q2.NAOK,q3.NAOK,q10.NAOK,q28.NAOK)>0,sum(q2.NAOK,q3.NAOK,q10.NAOK,q28.NAOK)/count(q2.NAOK,q3.NAOK,q10.NAOK,q28.NAOK),"/")}

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: c1v3ssss
The topic has been locked.
  • c1v3ssss
  • c1v3ssss's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
5 years 2 months ago #179022 by c1v3ssss
and i will be able to display the result for every participant?
The topic has been locked.
  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
5 years 2 months ago #179026 by DenisChenu

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 topic has been locked.

Lime-years ahead

Online-surveys for every purse and purpose