Willkommen, Gast Benutzername: Passwort: Angemeldet bleiben:

## Calculate a summ out of an array question 2 Jahre 5 Monate her #88175

 Einstein OFFLINE Junior Lime Beiträge: 27 Karma: 0 Hello, We are trying to put up an project selection for 40 participants. For each prjoject there are 5 criteria like quality, impact and so on. all of these criteria can be rated eather from 1 to 3 or 1 to 5 or... 1 o 8. I use the Q-type array (multiflexi 1-10). What i need in the end is a summ of all the points given for example by personX for project 4. And in the end I need a summ for all points given by all participants for project 4. I dont know how to use the Expression Manager for this purpose. I´ve been reading a lot about the Qcode.value but I can't find the right way to use it. I don´t need the summ to show up within the survey i only need the result in the end as a result in an excel sheet. One question is how to define the values for the different answeroptions from 1 to 7 as I am using the Q-type array (multiflexi 1-10) As I´m German I am not absolultely familiar with the english wording in lime. I turned on somethin thats called BEWERTUNGSMODUS in german. The english translation should be ASSESMENTMODE or EVALUATIONMODE. Here it seems like i can assign values to the different answerotions. Am I on the right track? Moreover I would like to know where and how to put the Qcode.value so that it calculates the way I described in the upper part of the text. Detailed description would be good as i am a bloody beginner BUT I´m thankfull for every hint. LimeSurvey Version 1.92+ Build 120919 Thanks Einstein Letzte Änderung: 2 Jahre 5 Monate her von Einstein. Der Administrator hat öffentliche Schreibrechte deaktiviert.

## Re: Calculate a summ out of an array question 2 Jahre 5 Monate her #88195

 tomscher OFFLINE Junior Lime Beiträge: 24 Dank erhalten: 5 Karma: 2 Please clarify: you want to sum up values of items although they use different scales (1-3, 1-5)? You also write something about "1 to 7", however I do not see any 7 answer options in your screenshot? Solution for your first sum: It would not be as simple as {question1.value + question2.value} and using a equation question type (=formula)? If you do not want to show this equation, then you may hide this question. Solution for your second sum (overall points given for project 4): This is less simple if you want to code it in Limesurvey. I think you may be able to do this using some php and javascript, but I think it's not worth it. Why don't you just use Excel or R or SPSS to compute that sum? Any reason why you want this in Limesurvey? In Excel it's just a simple sum / calculation.... Please look at the attached survey for more info of the first solution. Anhang: limesurvey...6865.lss (26KB) Der Administrator hat öffentliche Schreibrechte deaktiviert.

## Re: Calculate a summ out of an array question 2 Jahre 5 Monate her #88210

• Ben_V
• Platinum Lime
• Beiträge: 1301
• Dank erhalten: 303
• Karma: 87
Another sample survey and useful link

#### Dateianhang:

Dateiname: assess_EM.lss
Dateigröße: 29 KB

Ben/

## Aw: Re: Calculate a summ out of an array question 2 Jahre 5 Monate her #88262

 Einstein OFFLINE Junior Lime Beiträge: 27 Karma: 0 Thank you so much. It works!!! Only thing I haven´t found out yet is how to save this count in the results. It doesn´t show up on in my result excel-sheet in the end. Any recommendations? best regards Einstein Der Administrator hat öffentliche Schreibrechte deaktiviert.

## Aw: Re: Calculate a summ out of an array question 2 Jahre 5 Monate her #88285

 Ben_V OFFLINE Platinum Lime Beiträge: 1301 Dank erhalten: 303 Karma: 87 As shown in my previous sample survey you have to create an "equation" type question at the end of your survey to store this result.. Use the textarea of your question just to set your equation Example of basic syntaxis:`{sum(q1.value,q2.value,q3.value,q4.value)}` Benoît goo.gl/Bw5iM => Recherche GG dans le forum français (remplacer "exemple" dans la barre de recherche) goo.gl/WX8PH => GG search for english forum (Replace "example" in the search bar) goo.gl/IxiGu => Búsqueda en el foro en español (Cambiar "ejemplo" en la barra de... Der Administrator hat öffentliche Schreibrechte deaktiviert. Folgende Benutzer bedankten sich: TMSWhite

## Aw: Re: Calculate a summ out of an array question 2 Jahre 5 Monate her #88607

 Einstein OFFLINE Junior Lime Beiträge: 27 Karma: 0 Yep now it works! Thank you! Der Administrator hat öffentliche Schreibrechte deaktiviert.

## Re: Aw: Re: Calculate a summ out of an array question 2 Jahre 5 Monate her #88663

 DenisChenu OFFLINE Moderator Lime Beiträge: 7044 Dank erhalten: 943 Karma: 282 I test too with`{assessment_CURRENT_TOTAL}`: seems to work for 1.92. Have to test on 2.0 asse*sment in capital ... Auto help link is great , but not all the times Denis Assistance on LimeSurvey forum and LimeSurvey core developpement are on my free time (Say thanks ?). A bug not reported is a bug not corrected. | Please, read the documentation | La doc en français à besoin de vous Official LimeSurvey Partner | Web development | SkeletonQuest, RWD for LimeSurvey Letzte Änderung: 2 Jahre 5 Monate her von DenisChenu. Begründung: Auto help link is great Der Administrator hat öffentliche Schreibrechte deaktiviert.
Moderatoren: ITEd