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

More
5 months 2 weeks 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

Please Log in or Create an account to join the conversation.

LimeSurvey Partners
More
5 months 2 weeks ago #179019 by DenisChenu
Hi,

No average in Expression, but you can easily use this
{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 .
An error happen ? Before make a new topic : remind the Debug mode .
The following user(s) said Thank You: c1v3ssss

Please Log in or Create an account to join the conversation.

More
5 months 2 weeks ago #179022 by c1v3ssss
and i will be able to display the result for every participant?

Please Log in or Create an account to join the conversation.

More
5 months 2 weeks 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 .
An error happen ? Before make a new topic : remind the Debug mode .

Please Log in or Create an account to join the conversation.

Start now!

Just create your account and start using Limesurvey today.

Register now
Join our Newsletter!