aB2SLpHLCrTNEZDLVHAteW.xlsx (12.4 KB)
hello, I have been stuck in this since many many days now. I have really got frustrated. In this file, when I choose upon any option for any question, it takes up a value of 0, even when it has been assigned a value of 2. Please check and tell me how can I rectify this asap.
@Kal_Lam please help me with this , as soon as you see this
@nikhiladhav, could you kindly explain your issue here so that the community should be able to help you out? We would appreciate it if you just share the related part of your issue.
So , I have to create a questionnaire , wherein there are a total of 25 questions, options for these questions are same . But, the values assigned to these options are not same. They are varying according to question. I have allotted values properly in my excel sheet , but these values are not being taken up as assigned ,instead it just takes up 0, which is not the intended value. Please have a look at the excel sheet attached. There is no one around me who could help, I am totally dependent on this forum . This project is getting delayed
@nikhiladhav, the issue seems to be in your if-statement. When looking to your XLSForm I see the following under the survey sheet:
Similarly, I see the following under the choices sheet:
If you look at the if-statement you can see the following:
if(${q1} = 'Not _True', 0, if(${q1} = 'Somewhat_True', 1, if(${q1} = 'Certainly _True', 2, 0)))
Which should instead be as follows (based on the choices name):
if(${q1} = 0, 0, if(${q1} = 1, 1, if(${q1} = 2, 2, 0)))
Please note that you will always need to use the name code instead of the label from the choices sheet.
