topic Re: Calculate Emergency Help in ArcGIS Survey123 Questions

Calculate Emergency Help

TonyStrothers — Wed, 19 Apr 2017 16:58:50 GMT

HELP!!!!

I have a rush job and I cannot for the life of me figure out how to get this to work.

Here's the deal:

User selects one (select_one) calculation type for volume from a list of 6. For our example let's just say:

1. Times 10

2. Times 20

3. Times 30

4. Times 40

5. Times 50

6. Times 60

Next ... They are prompted to enter a volume. Let's say they enter 3

Let's say I chose option 4 in the select_one area above. So with my input of 3 they calculated value would be 120 (That's 40 X 3). So what I need to know is how I can do a calculate on the fly to look at their select_one choice for the calculation type for volume and then multiple it by the number entered. Storing that number that's been calculated in a single field and displaying it for the user.

Re: Calculate Emergency Help

Anonymous User — Wed, 19 Apr 2017 17:36:33 GMT

It sounds like you just need to create three fields –

Select_one question (dependent on how you setup the choices as “text” or “number” values for the “Times” number choice)
Volume (assuming this is a integer or decimal field)
Results of calculation (decimal or integer)

Within the calculations field (column M) you would enter the following formula if question one is an

integer or decimal (${Select_one})*(${Volume})
as text (number(${Select_one}))*(${Volume})
you could even apply the round function to get the results to be rounded to a certain decimal.

One thing I did forget to mention is that you could also use the pulldata request in order to pull a numeric value that is dependent upon the answer selected within your select_one question.

This link might be of help - http://doc.arcgis.com/en/survey123/desktop/create-surveys/xlsformformulas.htm

Good Luck!

Mike

Re: Calculate Emergency Help

TonyStrothers — Wed, 19 Apr 2017 18:01:29 GMT

Mike it worked perfectly. Thank you so much for taking the time to reply and share the knowledge. And also ... Thanks for saving the day!!!!

Re: Calculate Emergency Help

Anonymous User — Wed, 19 Apr 2017 18:06:44 GMT

Tony,

You will find through trial and error what works and what doesn't work and "No worries!" as I have been in the same position and someone helped me out.

Just giving back to the community.