I have a question on adding a new variable which is the sum of values entered in the previous questions. This variable is not a question but should be displayed as a note to the enumerator showing the the sum of values in the previous two question Can we create such variable within survey solution
thank you for the question. Yes it is possible to do it in Survey Solutions. We call this ‘calculated variables’ or simply ‘variables’. Right-click the last question, select ‘add variable’, specify type ‘Double’. In the expression field write your expression, e.g.:
Assign the name such as ‘total’.
This will calculate the sum.
You can include it into the text of the question or a static text with %total % .
Calculated variables will also be exported with your data.