Willkommen, Gast
Benutzername: Passwort: Angemeldet bleiben:

THEMA: cannot get the equation value in EM!

cannot get the equation value in EM! 9 Monate 2 Wochen her #109945

  • iscar
  • iscars Avatar
  • OFFLINE
  • Gold Lime
  • Beiträge: 226
  • Dank erhalten: 1
  • Karma: 0
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?
Der Administrator hat öffentliche Schreibrechte deaktiviert.

cannot get the equation value in EM! 9 Monate 2 Wochen her #109975

  • DenisChenu
  • DenisChenus Avatar
  • OFFLINE
  • Moderator Lime
  • Beiträge: 6953
  • Dank erhalten: 930
  • Karma: 278
Q1.NAOK : .NAOK - same as .code, but can be part of calculations or lists even if irrelevant .

Else give error
Der Administrator hat öffentliche Schreibrechte deaktiviert.

cannot get the equation value in EM! 9 Monate 2 Wochen her #109977

  • iscar
  • iscars Avatar
  • OFFLINE
  • Gold Lime
  • Beiträge: 226
  • Dank erhalten: 1
  • Karma: 0
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.
Der Administrator hat öffentliche Schreibrechte deaktiviert.

cannot get the equation value in EM! 9 Monate 2 Wochen her #109982

  • DenisChenu
  • DenisChenus Avatar
  • OFFLINE
  • Moderator Lime
  • Beiträge: 6953
  • Dank erhalten: 930
  • Karma: 278
BUT count(Q1,Q2,Q3,Q4) does error.

If you trye with (Q1.NAOK,Q2.NAOK,Q3.NAOK,Q4.NAOK) ?
Der Administrator hat öffentliche Schreibrechte deaktiviert.

cannot get the equation value in EM! 9 Monate 2 Wochen her #109989

  • iscar
  • iscars Avatar
  • OFFLINE
  • Gold Lime
  • Beiträge: 226
  • Dank erhalten: 1
  • Karma: 0
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.
Der Administrator hat öffentliche Schreibrechte deaktiviert.
Moderatoren: ITEd
Ladezeit der Seite: 0.165 Sekunden
Donation Image