Hi.
I have a survey with a few groups (G1, G2,...) each has a multiple questions all of type List(radio). Each answer has a value (A1 = 5, A2 = 4,...)

What I want is to export the sum of each group answers. E.g. G1 has three questions, with answers A1, A1, A2, which sums to 5+5+4=14, so G1's score should be 14

1- How can I export data in such a way
2- How can I produce reports in the same manner?

P.S. Pardon me if my language is unclear. I'm not a native English speaker.

Hi,
buzzword: Expression Manager.

1. It is much easier if you use numerical codes instead of the default "A1", "A2",...
2. Create questions of type equation (call them "scoreG1", "scoreG2", ..., or as you like)
In "scoreG1" you enter the equation
a. with your codes
{sum(if(Q1a=="A1",1,0),if(Q1a=="A2",2,0),if(Q1a=="A3",3,0),if(Q1a=="A4",4,0),if(Q1a=="A5",5,0), if(Q1b=="A1",1,0),if(Q1b=="A2",2,0),if(Q1b=="A3",3,0),if(Q1b=="A4",4,0),if(Q1b=="A5",5,0), if(Q1c=="A1",1,0),if(Q1c=="A2",2,0),if(Q1c=="A3",3,0),if(Q1c=="A4",4,0),if(Q1c=="A5",5,0))}

b. with your codes, but numerical answer option text
{sum(Q1a.shown,Q1b.shown,Q1c.shown)}

c. with numerical codes
{sum(Q1a.NAOK,Q1b.NAOK,Q1c.NAOK)}

d. you may use assessment values. If "A1" has the assessment value of 1, "A2" of 2, ...
{sum(Q1a.valueNAOK,Q1b.valueNAOK,Q1c.valueNAOK)}


And this variable "scoreG1" is stored in your database and you can use irt later in your survey like any other variable. ( {scoreG1} )

Joffm

Thanks @joffm

That's very useful. I'll give it a try and might come back with follow up

With appreciation