Help to make a report of a determinate zone in percentage that add up to 100%

Hello, i need help with my form, i want to make a report of a zone were i will take sampes, and i need to list diferent types of ambients (grassland, forest, urban edification, roads, etc) expressed in percentage.

I want to make the form “Force” me to no overpass the 100%, in example

Grassland 70%
Urban structure 10% --> in this part i want to limit the porcentaje i can mark to max 30%
Forest 30% —> and here i want to mark the max of 20% and dont let me select 30%

I dont know if its clear, any doubt i accept observations !

thank you so much

Hi @faraco123
Could you try using the below approach

Please find the attached excel below
Cumulative100Percent.xlsx (10.6 KB)


1 Like

Hi @faraco123,

I have made a small addition to the solution on what @stephanealoo has shared. It just tries to confirm you if you are OK with the cumulative 100% even if it does not check all the 5 line items.

In the survey tab of your xlsform:

In the choices tab of your xlsform:

Image 102

Data entry screen as seen in Enketo: (when 100% is met without having to fill up all 5 line items)

Data entry screen as seen in Enketo: (when 100% is met while filling up all 5 line items)

Reference xlsform:

Cumulative100Percent.xlsx (12.2 KB)