Welcome to the LimeSurvey Community Forum

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

cannot get the equation value in EM!

  • iscar
  • iscar's Avatar Topic Author
  • Offline
  • Elite Member
  • Elite Member
More
9 years 10 months ago #109945 by iscar
question type:equation
Code:
{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?
The topic has been locked.
  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
9 years 10 months ago #109975 by DenisChenu
Replied by DenisChenu on 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 , plugin development .
I don't answer to private message.
The topic has been locked.
  • iscar
  • iscar's Avatar Topic Author
  • Offline
  • Elite Member
  • Elite Member
More
9 years 10 months ago #109977 by iscar
Replied by iscar on 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.
The topic has been locked.
  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
9 years 10 months ago #109982 by DenisChenu
Replied by DenisChenu on 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 , plugin development .
I don't answer to private message.
The topic has been locked.
  • iscar
  • iscar's Avatar Topic Author
  • Offline
  • Elite Member
  • Elite Member
More
9 years 10 months ago #109989 by iscar
Replied by iscar on 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.
The topic has been locked.

Lime-years ahead

Online-surveys for every purse and purpose