Hello I am trying to get the average score from the answers from a rating question type. So what I did was I set default values to a hidden question based on what the user’s rating was. I used the coalesce to calculate the average rating the xls file can be uploaded successfully but it gives the error when I try to preview the form.
I can’t upload the file but here is the link for the excel file
There is a bracket missing in the Calculate “calctw” row 52 in ${A3,0}. It should be coalesce(${A3},0})
And also look for similarly bracket “}” missing in A5, B3, B5, C1, C3, C5, D1, D3, D5, E1, E3 and E5.
1 Like
@IANJOSEPH08, you should also be able to validate your XLSForm through this online validator. The online validator should help you identify syntax issues if any present within your XLSForm.