Calculation not working after using both pulldata() and user entered data - is it my syntax or something else?

RobertBohon — Tue, 19 May 2020 13:41:27 GMT

I have a simple survey where my calculations are not working. It is either my syntax for the calculation or where it calculations are in the survey.

The Survey calculates Gallons Per Minute. The user selects a station which uses pulldata() to draw depth and width values from a separate table. Then they enter in two other values for a beginning and ending test dimension. Once the user enters in the two other values, a calculation needs to take place using the pulldata() values and the user entered values.

The equation I am trying to use is the following one out of an Excel spreadsheet.

IF($B$6>0,$B$5*$B$6*(C11-C12)/12*7.48,3.14*($B$5/2)^2*(C11-C12)/12*7.48))

B5 and B6 are pulldata() values in the Survey, C11 and C12 are the user entered values for start/finish dimensions in the Survey.

I know that excel formulas don't translate over to Survey123 completely so I am wondering if my syntax for the equation could be wrong in Survey, or it is how I have it set up that is preventing it from running the calculations.

I broke up the excel IF statement into two calculations

1. $B$5*$B$6*(C11-C12)/12*7.48

2. 3.14*($B$5/2)^2*(C11-C12)/12*7.48

My versions of the excel formula in Survey

1. int(((${well_length}*${well_width})*(${pump1_draw_startlevel}-${pump1_draw_finishlevel})div12)*7.48)

2. int((3.14*(pow((${well_length}div2),2))*(${pump1_draw_startlevel}-${pump1_draw_finishlevel})div12)*7.48)

Any help would be appreciated.

Re: Calculation not working after using both pulldata() and user entered data - is it my syntax or something else?

JamesTedrick — Mon, 27 Jul 2020 16:26:19 GMT

Hi Robert,

Apologies for the delay. It looks like you have the positive and negative calculations switched in the form - the IF statement in Excel (like XLSForm) has the first outcome being when true and the second when false. Aside from that, I would need to see the Excel sheet you are trying to copy from in order to understand how well the XLSForm meets the formula.

topic Re: Calculation not working after using both pulldata() and user entered data - is it my syntax or something else? in ArcGIS Survey123 Questions

Calculation not working after using both pulldata() and user entered data - is it my syntax or something else?

Re: Calculation not working after using both pulldata() and user entered data - is it my syntax or something else?