summing transformed data issue
Posted: Wed Mar 05, 2025 1:36 pm
Hi!
I'm currently trying to sum a lot of questions that have been transformed, taking it from a 1-4 scoring to "0" and "1" ("0" for numbers originally scored 1&2, "1" for scores of 3&4). For some reason it has converted the continuous data into nominal, and I believe this is causing issues with summing the data.
So far what I have done it try "SUM('Q1t','Q2t'...)" for all data points which did not seem to work. I tried changing the transform variable's measure type from nominal to ordinal to continuous to see if that would allow me to sum the data, and it hasn't. I also tried breaking it into smaller parts to sum the data (ie. doing 5/10 points at a time) but that hasn't worked.
Any help would be appreciated!
I'm currently trying to sum a lot of questions that have been transformed, taking it from a 1-4 scoring to "0" and "1" ("0" for numbers originally scored 1&2, "1" for scores of 3&4). For some reason it has converted the continuous data into nominal, and I believe this is causing issues with summing the data.
So far what I have done it try "SUM('Q1t','Q2t'...)" for all data points which did not seem to work. I tried changing the transform variable's measure type from nominal to ordinal to continuous to see if that would allow me to sum the data, and it hasn't. I also tried breaking it into smaller parts to sum the data (ie. doing 5/10 points at a time) but that hasn't worked.
Any help would be appreciated!