cannot get the equation value in EM!

More
3 years 2 weeks ago #109945 by iscar
iscar created the topic: cannot get the equation value in EM!
question type:equation
{round((Q1.valueNAOK+Q2.valueNAOK+Q3.valueNAOK+Q4.valueNAOK)/count(Q1,Q2,Q3,Q4),2)}
because i set relevance of Q1,Q2,Q3,Q4.this equation question value should be :
if user relevant questions is Q1,Q2,Q4,should be of (Q1+Q2+Q4)/3.
if user relevant questions is Q1,Q3,should be of (Q1+Q4)/2.
BUT IN RESPONSE TABLE, THE VALUE IS 0.

what's the problem?

Please Log in to join the conversation.

More
3 years 2 weeks ago #109975 by DenisChenu
DenisChenu replied the topic: cannot get the equation value in EM!
Q1.NAOK : .NAOK - same as .code, but can be part of calculations or lists even if irrelevant .

Else give error

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand (or search sondages pro).
An error happen ? Before make a new topic : remind the Debug mode .

Please Log in to join the conversation.

More
3 years 2 weeks ago #109977 by iscar
iscar replied the topic: cannot get the equation value in EM!
i use Q1.valueNAOK,even Q1 is irrelevant, the Q1.valueNAOK is 0
it means no there's no error in Q1.valueNAOK.
and i check the response, Q1 is answered, the problem is {round((Q1.valueNAOK+Q2.valueNAOK+Q3.valueNAOK+Q4.valueNAOK)/count(Q1,Q2,Q3,Q4),2)} is 0.

Please Log in to join the conversation.

More
3 years 2 weeks ago #109982 by DenisChenu
DenisChenu replied the topic: cannot get the equation value in EM!
BUT count(Q1,Q2,Q3,Q4) does error.

If you trye with (Q1.NAOK,Q2.NAOK,Q3.NAOK,Q4.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 (or search sondages pro).
An error happen ? Before make a new topic : remind the Debug mode .

Please Log in to join the conversation.

More
3 years 1 week ago #109989 by iscar
iscar replied the topic: cannot get the equation value in EM!
as to count, q1 equal to q1.NAOK
i recreat the survey, this problem disappear.
i think the problem is about
Error executing query in dbExecuteAssoc:CDbCommand failed to execute the SQL statement: SQLSTATE[42S22]: Column not found: 1054 Unknown column
but i have no idea what cause this problem.

Please Log in to join the conversation.

Start now!

Just create your account and start using Limesurvey today.

Register now