Constraint - values entered in 3 questions must = 100

[taniak]

Hi Folks,

I am designing a form where 3 questions must be answered with a value (percentage). I would like to set a constraint, so that the sum of these 3 answers must equal 100. I cannot find anything in the forum topics to help me do this. Is this possible?

Thank you,
Tania

[hakan_cetinkaya]

Hi @taniak,

What are the type of your questions?

I believe we can do something with calculations.

[Kal_Lam]

@taniak, this post discussed previously should help you solve your issue:

How to calculate so that the total gives 100%

@gnd1, you could do this by adding 2 additional lines to the xlsform: In the survey tab of your xlsform: [Image 1] Data entry screen as seen in Enketo: when the total is below 100% [Image 2] Data entry screen as seen in Enketo: when the total is above 100% [Image 3] Data entry screen as seen in Enketo: when the total is equal to 100% [Image 4] Reference xlsform: Hundred Percent.xlsx (10.7 KB)

[taniak]

@Kal_Lam @hakan_cetinkaya, Thank you both - I failed to find this particular post.

[taniak]

@Kal_Lam @hakan_cetinkaya , I seem to have run into a problem. I have used the example to create a test version, but it seems not to work when I check the form out in Preview, and I cannot even deploy the form. Have I somehow made an error in my syntax?

I have attached my xls file and a screenshot of what happens when I have deliberately made an incorrect entry that I subsequently correct.

BBCH Test.xlsx (10.2 KB)

Thanks for your help.
Tania

[Kal_Lam]

@taniak, have you played around with this XLSForm to understand how it works?

How to calculate so that the total gives 100%

@gnd1, you could do this by adding 2 additional lines to the xlsform: In the survey tab of your xlsform: [Image 1] Data entry screen as seen in Enketo: when the total is below 100% [Image 2] Data entry screen as seen in Enketo: when the total is above 100% [Image 3] Data entry screen as seen in Enketo: when the total is equal to 100% [Image 4] Reference xlsform: Hundred Percent.xlsx (10.7 KB)

[Kal_Lam]

@taniak, the problem was with your expression here:
${bbch_percent_ave}!=" and ${bbch_percent_lo}!=" and ${bbch_percent_hi}!=" and ${bbch_calc}!=100 where you have used " instead of ' '.

Here is your refined XLSForm:

BBCH Test.xlsx (9.4 KB)

[taniak]

@Kal_Lam , Ouf, I did not notice the difference in this syntax. Even when I had your version and my version open together, it was only by backspacing over the characters that I realised you had 2x ’ and I had 1x "! I figured it was my syntax, but I couldn’t spot the difference visually, even when I zoomed in. So that it is clear to me next time I need to repeat this, I have put a space in between the the 2 ’ marks (’ '), so it is obvious that they are single quotes. I have tested this, and it works - perhaps it would be worth updating the hundred percent xlsx sheet to make it obvious to the next folk who want to do this? Or, perhaps I should have just copied from here & pasted into mine, and then changed the question names… Anyhow, very many thanks. Tania

[Kal_Lam]

@taniak,