|
|
I only see the formulas. The form is already really simple with just 3 basic questions. I need at least 3 to make sure the grade part works on the form, which it does, but it fails when viewing the responses or exporting the responses to an XLSX. I attached a response export from a new form entry. I also included a screenshot of the response screen. The use case for this is to create a form to evaluate student teachers in a classroom setting and the evaluator wants to calculate a grade based on responses entered and to exclude empty responses from the grading.
results-survey179947 (6).csv (1,381 bytes)
"Response ID","Date submitted","Last page","Start language","Seed","Date started","Date last action","IP address","Name","How good is the teacher ","Is the room clean","How did they treat the students ","Running Total: {sum(Good.valueNAOK, Treat.valueNAOK, Clean.valueNAOK)} Grade: {if((if(is_empty(Good),0,5)+if(is_empty(Treat),0,5)+if(is_empty(Clean),0,5))==0,0,round(sum(Good.valueNAOK,Treat.valueNAOK,Clean.valueNAOK)/(if(is_empty(Good),0,5)+if(is_empty(Treat),0,5)+if(is_empty(Clean),0,5))*100))}% ","","","Total time","Group time: My first question group","Question time: Name","Question time: Good","Question time: Clean","Question time: Treat","Question time: RunnintTotal","Question time: Grade","Question time: GradePCT"
"4","2026-09-17 19:45:40","1","en","1816213058","2026-09-17 19:45:29","2026-09-17 19:45:40","10.10.40.213","Tim","2","4","4","sum(Good.valueNAOK, Treat.valueNAOK, Clean.valueNAOK)","if((if(is_empty(Good),0,5)+if(is_empty(Treat),0,5)+if(is_empty(Clean),0,5))==0,0,round(sum(Good.valueNAOK,Treat.valueNAOK,Clean.valueNAOK)/(if(is_empty(Good),0,5)+if(is_empty(Treat),0,5)+if(is_empty(Clean),0,5))*100))","if((if(is_empty(Good),0,5)+if(is_empty(Treat),0,5)+if(is_empty(Clean),0,5))==0,0,round(sum(Good.valueNAOK,Treat.valueNAOK,Clean.valueNAOK)/(if(is_empty(Good),0,5)+if(is_empty(Treat),0,5)+if(is_empty(Clean),0,5))*100))","10.53","10.53",,,,,,,
|
c_schmitz
2026-09-17 21:54
administrator
~85832
Last edited: 2026-09-17 22:10
|
I looked into this using your exact formula, and the issue is in how the calculation is entered rather than a bug in the export.
For an Equation question, the formula in the "Equation" setting (in the question's Logic settings) must be wrapped in curly braces { } to be recognized as a calculation. Without the braces, LimeSurvey treats it as plain text — which is why you're seeing the raw formula instead of a computed number in the export.
So instead of:
sum(Good.valueNAOK, Treat.valueNAOK, Clean.valueNAOK)
it needs to be:
{sum(Good.valueNAOK, Treat.valueNAOK, Clean.valueNAOK)}
Please update all three of your equation formulas (the running total, the grade, and the grade percentage) to wrap them in { }, then re-test. That will make them evaluate correctly and save in the response data. |
