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

User Support Form Building
, , ,
1

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

2

Hi @faraco123
Could you try using the below approach

image
image1798×244 18.5 KB

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

Stephane

1 Like
3

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:

Image 101
Image 1011792×315 64.5 KB

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)

Image 103
Image 103642×838 20.3 KB

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

Image 104
Image 104643×835 19.1 KB

Reference xlsform:

Cumulative100Percent.xlsx (12.2 KB)