I need to put a formula on survey 123 to calculate BMI (Body Mass Index). Can someone help me please with how to do that?
Well, the formula for BMI is BMI = kg/m2 so you'll need a question for weight (in kg) and height (in meters). Then you just reference those fields in the calculation column of the XLS form (if you're using Survey123 Connect). Are you using connect, or the web form?
The calculation would look something like this:
${weight} div (${height} * ${height})
Thank you very much it worked! Really appreciate
Ah ok. In this case, I would set up individual "note" type questions that will display conditionally based on the answer selected in the measurement question. You can use HTML formatting in the "Label" column of the XLS form. See example below:
As always thank you so much it works !
Hi Katherine. thanks. Very helpful advice. I am using connect. I will try to use the formula
Hello I think I am doing something wrong I used the formula and didn't get the calculation . Can you please help?
It looks like you entered the calculation under the "Hint" column in the XLS form. You need to have a separate field (row in the XLS form) that will return the value of the calculation (the BMI). For this row, you enter the calculation expression in the "Calculation" column of the XLS form.
Dear Katherine, that's for your help last time I have another problem for some reason in one of the multiply questions the survey automatically pick up all questions through I want only 1. Thanks in advance
I'm happy to help, but can you provide a bit more detail? Maybe some screenshots of the XLS form or something?
Membros conectados podem postar, seguir atualizações e mais. Novo aqui? Registre uma conta gratuita.
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.
