Survey123 - Invalid calculate for the bind in 'if' statement - bad node

DianneGray2

Hi, I'm having a lot of trouble getting a calculate statement to work.  I am trying to set a conditional statement for "Average Test Pressure" so that it does the following: 

• If there is only one gauge, take 3 readings (0h,1h, and 2 h) and average them, multiply by 6.89476 to get kPa from psi, and round to 0 decimals
• If there are two gauges, take all 6 readings (0h,1h, and 2 h) for both the higher and lower gauge readings, average them, multiply by 6.89476 to get kPa from psi, and round to 0 decimals

However, I keep getting the error that says Invalid calculate for the bind attached to Average Test Pressure: Bad node.

I tried playing with the Esri Field Types to make them all double, and the bind type to decimal, but this does not fix my problem.  I need help spotting the problem and fixing it.

I've attached the XLS form.

Any help would be great.

Thanks!

 

Water Main Field Tests - for troubleshooting.xlsx

OIP.jpg

Jim Moore

Hi @dgray thanks for including your XLSForm, the if() statement is very close! Just need to ensure the parentheses are positioned correctly so that each nested if() is fully enclosed with all three of its arguments, and also that the parentheses around the round() functions are in the right place. Also, an if() statement must contain three arguments: if(condition, value if true, value if false). The 'false' value for the second if() is missing. Your expression could look something like:

if(${Gauge_Count} = 1, round((((${Pressure_Test_0h} + ${Pressure_Test_1h} + ${Pressure_Test_2h}) div 3) * 6.89476),0), if(${Gauge_Count} = 2, round((((${Press_Test_High_0h} + ${Press_Test_High_1h} + ${Press_Test_High_2h} + ${Press_Test_Low_0h} + ${Press_Test_Low_1h} + ${Press_Test_Low_2h}) div 6)*6.89476),0), 99999))

I've used 99999 for the final 'false' value, but you could replace this with '' for blank.

Hope this helps. Best, Jim