Good day,

I have a survey with 5 question groups
Each group has a List(radio) question
Based on the answer it it show the second question

I have enabled assessment on the survey and assigned values to the radio selections

Now my problem:
I want to record the value in the database for each question group.
I used a equation question at the end of each question group that displays ASSESSMENT_CURRENT_TOTAL
The problem is that this value increases based on the previous question groups.
I need to get a total just for the current question group only

I tried {ASSESSMENT_CURRENT_TOTAL}-{Tot1.value} but that just shows 3 - 2 in the database instead of 1

Any help will be appreciated.

The easiest way would be to assign the answer codes as the "score" instead of using assessments. Then your equation would simply be something like:
Or, if there are multiple questions on a page:

Thanks but this brings in a new issue as I have two answers that get 0 score.

Then you'll need to use IF statements (line-breaks inserted for clarity):

That worked perfectly, thank you.

Just a quick sanity check, to get the sum of all these I would use the following formula?

{sum(Tot1.value, Tot2.value, Tot3.value)}

(Tot1 etc is my if question code)

Yes the {sum(Tot1.value, Tot2.value, Tot3.value)} do the trick.

For the 1st issue : can you send a little survey file ? I'm unsure it must do something like this : if your survey is group by groiup and you add an assesment equation : each assesment equation must be different ( 1st is for 1st group, 2nd for 2nd group + 1st group etc ..., EXCEPT is user move previous ....)

@Denis, the original post said "I need to get a total just for the current question group only.

Yes, i know, but after is just a question of Math :

AssessGroup1: {assessment_CURRENT_TOTAL}
AssessGroup2: {assessment_CURRENT_TOTAL-AssessGroup1}
AssessGroup3: {assessment_CURRENT_TOTAL-AssessGroup1-AssessGroup2}

BUT : there are issue if user move previous back / move next