topic Re: Formula in ArcGIS Survey123 Questions

Formula

DrJumaKhudonazarov — Mon, 18 Jul 2022 17:53:18 GMT

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?

Re: Formula

Katie_Clark — Tue, 19 Jul 2022 13:46:10 GMT

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})

Re: Formula

DrJumaKhudonazarov — Tue, 19 Jul 2022 16:01:08 GMT

Hi Katherine. thanks. Very helpful advice. I am using connect. I will try to use the formula

Re: Formula

DrJumaKhudonazarov — Wed, 20 Jul 2022 00:40:14 GMT

Hello I think I am doing something wrong I used the formula and didn't get the calculation . Can you please help?

Re: Formula

Katie_Clark — Wed, 20 Jul 2022 13:34:31 GMT

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.

Re: Formula

DrJumaKhudonazarov — Wed, 20 Jul 2022 15:02:42 GMT

Thank you very much it worked! Really appreciate

Re: Formula

DrJumaKhudonazarov — Thu, 18 Aug 2022 08:48:03 GMT

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

Re: Formula

Katie_Clark — Thu, 18 Aug 2022 13:35:52 GMT

I'm happy to help, but can you provide a bit more detail? Maybe some screenshots of the XLS form or something?

Re: Formula

DrJumaKhudonazarov — Fri, 23 Dec 2022 20:49:49 GMT

Dear Katherine if you have time can you please advise. I have 3 variables <80cm low risk for CVD: 81-102cm medium risk for CVD and > 103 high risk for CVD. I want to have risk matrix graph where I want to see only risk , low, medium and high . is there any formula or colour similiar to traffic light I can use

Re: Formula

Katie_Clark — Tue, 27 Dec 2022 14:46:20 GMT

I'd love to help, but I'm really not quite sure what you're asking...

Are you asking about how to format the color of the text? Or something else?

Re: Formula

DrJumaKhudonazarov — Tue, 27 Dec 2022 20:03:56 GMT

Sorry for not being clear. I have 3 measurements

1. <80 cm :

2. 81-102 cm

3.> 103 cm.

And there 3 risk groups@

1. Low

2. Medium

3. High

What i want is that if i select >103 cm the answer in next question should automatically appear as red colour text High risk, this may not affect analysis but the person who measure WC can explain the risk for that person .

Re: Formula

Katie_Clark — Tue, 27 Dec 2022 20:35:12 GMT

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:

Re: Formula

DrJumaKhudonazarov — Wed, 28 Dec 2022 11:35:00 GMT

As always thank you so much it works !