i have 6 questions (number type), the summation of the 6 Should be 100, how can i do the validation during the entry level , if the sum is not 100 then error should come out forcing the respondent to review and fix
Kal_Lam
December 30, 2024, 7:21am
2
@fayez_70 , this post discussed previously should help you solve your issue:
@gnd1 , you could do the same as outlined in the image below:
In the survey tab of your xlsform:
[image]
Data entry screen as seen in Enketo: when a wrong entry is made
[image]
Data entry screen as seen in Enketo: when a correct entry is made
[image]
Reference xlsform:
Hundred Percent.xlsx (10.5 KB)
And this post too …
Hi @LuisB ,
You could do the same as outlined in the image below:
In the survey tab of your xlsform:
[Image 101]
In the choices tab of your xlsform:
[Image 102]
Data entry screen as seen in Enketo: (when the percentage exceeds 100)
[Image 103]
Data entry screen as seen in Enketo: (when the percentage does not exceed 100)
[Image 104]
Reference xlsform:
Cumulative Percentage 100.xlsx (11.6 KB)
