Hello, I am not able to calculate the sum of the variables. I have attached my xls form workbook1.xlsx (10.4 KB) for reference. Here I have two issues, 1) I want to restrict only one response for each coloumn (for eg. for grade A- only one response such as 0,1 or 2 on right and same on the left).
2) 0,1, and 2 are the values, so in calculate I require the sum of Grade A, Grade B and Grade C with (for eg. In Grade A if I have ticked 0 for right and 2 for left then the sum should be 2). I think I am able to explain myself. Please help.
Users should only be able to select one response form a group and then these response should be summed at the bottom
Welcome back to the community, @Ash! So if I got you correct you mean, the enumerators should only be able to select one response from in
Right and one response in
Left for each Group (A, B & C) as shown in the image below?
And once it’s selected as shown the sum score of all the A, B & C should appear on the bottom. Did I get you correct?
Yes, absolutely right. thanks
Did you had any luck with the query. I am unable to find any solution. Please help. Regards
I posted the query about sum. Can anybody help in the solution please. regards,
@Ash, maybe you could do it as outlined in the image shared below:
Workbook.xlsx (12.9 KB)
Thank you very much. Got it