The two files are attached. Thank you!
The two files are attached. Thank you!
Hi cam15. I ran the files you uploaded and got the same kind of error. I got rid of it when I changed the names of the calculated variables, the ones that ended with opt in rows 10-17 of your responses.xls file. I just named them a1-a8 and the values from the formulas in cells b10-17 showed up as expected.
I'm going to look into why this was not working, but for now, you should be able to get around it by simply choosing different names for the calculated variables.
Jason Reed
Empirisoft Software Support Specialist
Thanks for looking in to this.
Hi cam15,
Just checking in to see if your study files are functioning as intended.
Jason Reed
Empirisoft Software Support Specialist
Hi Jason,
Yes they are, thank you. I believe there is an issue with using caps in the variable names that won't allow the responses to embed into subsequent questions. I'm not sure if it is using caps in the original variables names or in the new variables with the equations in the responses file, but I changed them to all lowercase letters and they are working now.
Thanks!
I'm glad to hear that everything is functioning. However, I'd be surprised if using capital letters was the cause of the problem. You should also be able to use capital letters in your variable names. If it's not too much trouble, could you tell me the what the old names of the problem variables were and what you changed them to?
Jason Reed
Empirisoft Software Support Specialist
I changed the original document I uploaded and can't seem to open it now, so I'm not completely sure about the old variable names, but I believe they were as follows:
OLD VARIABLE
multiple response question name = "DSM11a"
NEW VARIABLE
multiple response question name = "dsm11a"
In responses file, answer choices (these are the variables that include the =IF( , ) statements:
OLD VARIABLES NEW VARIABLES
DSM11a01opt dsm11a01
DSM11a02opt dsm11a02
DSM11a03opt dsm11a03
DSM11a04opt dsm11a04
DSM11a05opt dsm11a05
DSM11a06opt dsm11a06
DSM11a07opt dsm11a07
DSM11a08opt dsm11a08
If you are still able to open the files from my previous post, you can double-check what the old variable names were. I changed the variable names to lowercase letters and omitted the "opt" at the end to simplify.