How to calculate so that the total gives 100%

I want to know if it is possible to provide a calculation on several questions (4 for example) so the sum must give 100%

Maybe you could follow the post that has been discussed previously (it should solve your issue):

j’ai essayé mais ça n’a pas marché. pouvez vous le faire sur ce fichier Classeur1.xlsx (8.8 KB)

@gnd1, you could do the same as outlined in the image below:

In the survey tab of your xlsform:

Data entry screen as seen in Enketo: when a wrong entry is made

Data entry screen as seen in Enketo: when a correct entry is made

Reference xlsform:

Hundred Percent.xlsx (10.5 KB)

merci, mais je veux que le total ne soit pas superieur à 100% ni inferieur à 100%, il doit etre egal à 100%.
or ce que vous avait présenté, ne remplis pas le deux conditions directement.

@gnd1, you could do this by adding 2 additional lines to the xlsform:

In the survey tab of your xlsform:

Data entry screen as seen in Enketo: when the total is below 100%

Data entry screen as seen in Enketo: when the total is above 100%

Data entry screen as seen in Enketo: when the total is equal to 100%

Reference xlsform:

Hundred Percent.xlsx (10.7 KB)

1 Like