Am trying to get the output of multiple results at the same time.
Using a select-many option, I would wish that every correct selection gives the results for a Quiz in the NOTE variable using XLS Forms…
My success so far works with only one (of the select-multiple) being correct. Any further correct additions selected (say three are correct out of four) do not give the result. I have to delete the extra additions for it to give the accurate result.
I need it to give a cumulative score, in that:-- If one is correct and selected, then 1 is assigned (0r whatever value given).
If second correct selection is made, it sums them and assigns 2.
Or in the event all four are correct and selected, it sums them assigning that value, in this case 4.
I would appreciate the calculate formula that would make this happen. Below is an example of one of the variations I have gone thru not yielding the desired result.
type
name
label
calculation
start
start
end
end
select_multiple q1
q1
1. Check calc 3 correctly selected
calculate
c1
if(${q1},‘1’,1 or if(${q1},‘3’,1 or if(${q1},‘4’, 1,0)))