topic Calculate field calculating even when question is not relevant in ArcGIS Survey123 Questions

topic Calculate field calculating even when question is not relevant in ArcGIS Survey123 Questions https://community.esri.com/t5/arcgis-survey123-questions/calculate-field-calculating-even-when-question-is/m-p/800276#M10609 <HTML><HEAD></HEAD><BODY><P>I have a section of my Survey123 form that is only relevant if the inspector is completing the "Full" vs. the "Simple"; however, the calculate field (q_sum) within the group is calculating even when the simple form is completed, as is the question dependent on the calculate field (behi). I do not want these fields to calculate or autofill if the "Simple" form is being completed. When completing the "Simple" none of the questions in the group appear, but in the data table a value of "0" is present for q_sum and a value of "Low" is present for behi. I have tried leaving the relevant column blank, as well as several other scenarios, and always the q_sum and behi fields are completed. Anyone have any suggestions of what I am doing wrong?</P><P></P><TABLE width="4698"><TBODY><TR><TD style="font-size: 10.0pt; color: white; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: .5pt solid #9BBB59; background: gray;" width="162">begin group</TD><TD style="font-size: 10.0pt; color: white; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none; background: gray;" width="145">second_group</TD><TD style="font-size: 10.0pt; color: white; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none; background: gray;" width="371">BEHI Pre-Screening:</TD><TD style="font-size: 10.0pt; color: white; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none; background: gray;" width="173">If "Yes" to 2 or more of the following questions, perform BEHI.  If not, BEHI = Low.</TD><TD style="font-size: 10.0pt; color: white; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none; background: gray;" width="101"> </TD><TD style="font-size: 10.0pt; color: white; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none; background: gray;" width="166"> </TD><TD style="font-size: 10.0pt; color: white; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none; background: gray;" width="93"> </TD><TD style="font-size: 10.0pt; color: white; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none; background: gray;" width="228"> </TD><TD style="font-size: 10.0pt; color: white; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none; background: gray;" width="115"> </TD><TD style="font-size: 10.0pt; color: white; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none; background: gray;" width="83"> </TD><TD style="font-size: 10.0pt; color: white; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none; background: gray;" width="95"> </TD><TD style="font-size: 10.0pt; color: white; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none; background: gray;" width="303">${Insp_type}="Full"</TD><TD style="font-size: 10.0pt; color: white; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none; background: gray;" width="180"> </TD><TD style="font-size: 10.0pt; color: white; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none; background: gray;" width="117"> </TD><TD style="font-size: 10.0pt; color: white; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none; background: gray;" width="122"> </TD><TD style="font-size: 10.0pt; color: white; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none; background: gray;" width="147"> </TD><TD style="font-size: 10.0pt; color: white; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none; background: gray;" width="139"> </TD><TD style="font-size: 10.0pt; color: white; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none; background: gray;" width="124"> </TD><TD style="font-size: 10.0pt; color: white; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none; background: gray;" width="128"> </TD><TD style="font-size: 10.0pt; color: white; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none; background: gray;" width="201"> </TD><TD style="font-size: 10.0pt; color: white; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none; background: gray;" width="163"> </TD><TD style="font-size: 10.0pt; color: white; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none; background: gray;" width="176"> </TD><TD style="font-size: 10.0pt; color: white; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none; background: gray;" width="163"> </TD><TD style="font-size: 10.0pt; color: white; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none; background: gray;" width="171"> </TD><TD style="font-size: 10.0pt; color: white; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none; background: gray;" width="176"> </TD><TD style="font-size: 10.0pt; color: white; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none; background: gray;" width="177"> </TD><TD style="font-size: 10.0pt; color: white; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none; background: gray;" width="102"> </TD><TD style="font-size: 10.0pt; color: white; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none; background: gray;" width="156"> </TD><TD style="font-size: 10.0pt; color: white; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: .5pt solid #9BBB59; border-bottom: none; border-left: none; background: gray;" width="221"> </TD></TR><TR><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: .5pt solid #9BBB59;">select_one yes_no</TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;">prescrn_q1</TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;" width="371">Does the bank exhibit less than or equal to 50% protection at the toe?</TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;" width="173"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;" width="166"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;">yes</TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;" width="228">All 6 BEHI Pre-screening questions must be answered.</TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;" width="303"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;" width="180"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: .5pt solid #9BBB59; border-bottom: none; border-left: none;"></TD></TR><TR><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: .5pt solid #9BBB59;">select_one yes_no</TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;">prescrn_q2</TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;" width="371">Does 50% or more of the bank exhibit an undercut of 6 inches or more?</TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;" width="173"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;" width="166"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;">yes</TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;" width="228">All 6 BEHI Pre-screening questions must be answered.</TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;" width="303"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;" width="180"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: .5pt solid #9BBB59; border-bottom: none; border-left: none;"></TD></TR><TR><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: .5pt solid #9BBB59;">select_one yes_no</TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;">prescrn_q3</TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;" width="371">Does 50% or more of the bank exhibit stratification where at least one layer is erodible material?</TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;" width="173"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;" width="166"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;">yes</TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;" width="228">All 6 BEHI Pre-screening questions must be answered.</TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;" width="303"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;" width="180"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: .5pt solid #9BBB59; border-bottom: none; border-left: none;"></TD></TR><TR><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: .5pt solid #9BBB59;">select_one yes_no</TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;">prescrn_q4</TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;" width="371">Does 50% or more of the bank have a bank height of 10 feet or more with 50% or more soil exposure?</TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;" width="173"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;" width="166"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;">yes</TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;" width="228">All 6 BEHI Pre-screening questions must be answered.</TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;" width="303"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;" width="180"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: .5pt solid #9BBB59; border-bottom: none; border-left: none;"></TD></TR><TR><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: .5pt solid #9BBB59;">select_one yes_no</TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;">prescrn_q5</TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;" width="371">Does 50% or more of the bank exhibit roots lacking bank soil material?</TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;" width="173"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;" width="166"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;">yes</TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;" width="228">All 6 BEHI Pre-screening questions must be answered.</TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;" width="303"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;" width="180"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: .5pt solid #9BBB59; border-bottom: none; border-left: none;"></TD></TR><TR><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: .5pt solid #9BBB59;">select_one yes_no</TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;">prescrn_q6</TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;" width="371">Is 50% or more of the bank void of rooted vegetation?</TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;" width="173"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;" width="166"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;">yes</TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;" width="228">All 6 BEHI Pre-screening questions must be answered.</TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;" width="303"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;" width="180"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: .5pt solid #9BBB59; border-bottom: none; border-left: none;"></TD></TR><TR><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: .5pt solid #9BBB59;">calculate</TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;">q_sum</TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;" width="371">Sum of Questions:</TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;" width="173"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;" width="166"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;" width="228"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;" width="303">${prescrn_q1} != '' and ${prescrn_q2} != '' and ${prescrn_q3} != '' and ${prescrn_q4} != '' and ${prescrn_q5} != '' and ${prescrn_q6} != ''</TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;" width="180">number(${prescrn_q1}) + number(${prescrn_q2}) + number(${prescrn_q3}) + number(${prescrn_q4}) + number(${prescrn_q5}) + number(${prescrn_q6})</TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: .5pt solid #9BBB59; border-bottom: none; border-left: none;"></TD></TR><TR><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: .5pt solid #9BBB59;">text</TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;">behi</TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;" width="371">BEHI:</TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;" width="173"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;" width="166"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;" width="228"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;">yes</TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;" width="303">${prescrn_q1} != '' and ${prescrn_q2} != '' and ${prescrn_q3} != '' and ${prescrn_q4} != '' and ${prescrn_q5} != '' and ${prescrn_q6} != ''</TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;" width="180">if(${q_sum} < 2, 'Low', 'Perform BEHI')</TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: .5pt solid #9BBB59; border-bottom: none; border-left: none;"></TD></TR><TR><TD style="font-size: 10.0pt; color: white; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: .5pt solid #9BBB59; background: gray;">end group</TD><TD style="font-size: 10.0pt; color: white; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none; background: gray;"> </TD><TD style="font-size: 10.0pt; color: white; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none; background: gray;" width="371"> </TD><TD style="font-size: 10.0pt; color: white; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none; background: gray;" width="173"> </TD><TD style="font-size: 10.0pt; color: white; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none; background: gray;"> </TD><TD style="font-size: 10.0pt; color: white; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none; background: gray;" width="166"> </TD><TD style="font-size: 10.0pt; color: white; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none; background: gray;"> </TD><TD style="font-size: 10.0pt; color: white; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none; background: gray;" width="228"> </TD><TD style="font-size: 10.0pt; color: white; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none; background: gray;"> </TD><TD style="font-size: 10.0pt; color: white; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none; background: gray;"> </TD><TD style="font-size: 10.0pt; color: white; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none; background: gray;"> </TD><TD style="font-size: 10.0pt; color: white; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none; background: gray;" width="303"> </TD><TD style="font-size: 10.0pt; color: white; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none; background: gray;" width="180"> </TD><TD style="font-size: 10.0pt; color: white; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none; background: gray;"> </TD><TD style="font-size: 10.0pt; color: white; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none; background: gray;"> </TD><TD style="font-size: 10.0pt; color: white; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none; background: gray;"> </TD><TD style="font-size: 10.0pt; color: white; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none; background: gray;"> </TD><TD style="font-size: 10.0pt; color: white; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none; background: gray;"> </TD><TD style="font-size: 10.0pt; color: white; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none; background: gray;"> </TD><TD style="font-size: 10.0pt; color: white; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none; background: gray;"> </TD><TD style="font-size: 10.0pt; color: white; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none; background: gray;"> </TD><TD style="font-size: 10.0pt; color: white; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none; background: gray;"> </TD><TD style="font-size: 10.0pt; color: white; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none; background: gray;"> </TD><TD style="font-size: 10.0pt; color: white; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none; background: gray;"> </TD><TD style="font-size: 10.0pt; color: white; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none; background: gray;"> </TD><TD style="font-size: 10.0pt; color: white; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none; background: gray;"> </TD><TD style="font-size: 10.0pt; color: white; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none; background: gray;"> </TD><TD style="font-size: 10.0pt; color: white; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none; background: gray;"> </TD><TD style="font-size: 10.0pt; color: white; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: .5pt solid #9BBB59; border-bottom: none; border-left: none; background: gray;"> </TD></TR></TBODY></TABLE></BODY></HTML> Thu, 28 Feb 2019 18:30:34 GMT LJackson29 2019-02-28T18:30:34Z Calculate field calculating even when question is not relevant https://community.esri.com/t5/arcgis-survey123-questions/calculate-field-calculating-even-when-question-is/m-p/800276#M10609 <HTML><HEAD></HEAD><BODY><P>I have a section of my Survey123 form that is only relevant if the inspector is completing the "Full" vs. the "Simple"; however, the calculate field (q_sum) within the group is calculating even when the simple form is completed, as is the question dependent on the calculate field (behi). I do not want these fields to calculate or autofill if the "Simple" form is being completed. When completing the "Simple" none of the questions in the group appear, but in the data table a value of "0" is present for q_sum and a value of "Low" is present for behi. I have tried leaving the relevant column blank, as well as several other scenarios, and always the q_sum and behi fields are completed. Anyone have any suggestions of what I am doing wrong?</P><P></P><TABLE width="4698"><TBODY><TR><TD style="font-size: 10.0pt; color: white; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: .5pt solid #9BBB59; background: gray;" width="162">begin group</TD><TD style="font-size: 10.0pt; color: white; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none; background: gray;" width="145">second_group</TD><TD style="font-size: 10.0pt; color: white; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none; background: gray;" width="371">BEHI Pre-Screening:</TD><TD style="font-size: 10.0pt; color: white; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none; background: gray;" width="173">If "Yes" to 2 or more of the following questions, perform BEHI.  If not, BEHI = Low.</TD><TD style="font-size: 10.0pt; color: white; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none; background: gray;" width="101"> </TD><TD style="font-size: 10.0pt; color: white; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none; background: gray;" width="166"> </TD><TD style="font-size: 10.0pt; color: white; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none; background: gray;" width="93"> </TD><TD style="font-size: 10.0pt; color: white; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none; background: gray;" width="228"> </TD><TD style="font-size: 10.0pt; color: white; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none; background: gray;" width="115"> </TD><TD style="font-size: 10.0pt; color: white; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none; background: gray;" width="83"> </TD><TD style="font-size: 10.0pt; color: white; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none; background: gray;" width="95"> </TD><TD style="font-size: 10.0pt; color: white; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none; background: gray;" width="303">${Insp_type}="Full"</TD><TD style="font-size: 10.0pt; color: white; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none; background: gray;" width="180"> </TD><TD style="font-size: 10.0pt; color: white; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none; background: gray;" width="117"> </TD><TD style="font-size: 10.0pt; color: white; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none; background: gray;" width="122"> </TD><TD style="font-size: 10.0pt; color: white; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none; background: gray;" width="147"> </TD><TD style="font-size: 10.0pt; color: white; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none; background: gray;" width="139"> </TD><TD style="font-size: 10.0pt; color: white; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none; background: gray;" width="124"> </TD><TD style="font-size: 10.0pt; color: white; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none; background: gray;" width="128"> </TD><TD style="font-size: 10.0pt; color: white; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none; background: gray;" width="201"> </TD><TD style="font-size: 10.0pt; color: white; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none; background: gray;" width="163"> </TD><TD style="font-size: 10.0pt; color: white; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none; background: gray;" width="176"> </TD><TD style="font-size: 10.0pt; color: white; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none; background: gray;" width="163"> </TD><TD style="font-size: 10.0pt; color: white; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none; background: gray;" width="171"> </TD><TD style="font-size: 10.0pt; color: white; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none; background: gray;" width="176"> </TD><TD style="font-size: 10.0pt; color: white; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none; background: gray;" width="177"> </TD><TD style="font-size: 10.0pt; color: white; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none; background: gray;" width="102"> </TD><TD style="font-size: 10.0pt; color: white; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none; background: gray;" width="156"> </TD><TD style="font-size: 10.0pt; color: white; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: .5pt solid #9BBB59; border-bottom: none; border-left: none; background: gray;" width="221"> </TD></TR><TR><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: .5pt solid #9BBB59;">select_one yes_no</TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;">prescrn_q1</TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;" width="371">Does the bank exhibit less than or equal to 50% protection at the toe?</TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;" width="173"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;" width="166"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;">yes</TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;" width="228">All 6 BEHI Pre-screening questions must be answered.</TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;" width="303"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;" width="180"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: .5pt solid #9BBB59; border-bottom: none; border-left: none;"></TD></TR><TR><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: .5pt solid #9BBB59;">select_one yes_no</TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;">prescrn_q2</TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;" width="371">Does 50% or more of the bank exhibit an undercut of 6 inches or more?</TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;" width="173"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;" width="166"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;">yes</TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;" width="228">All 6 BEHI Pre-screening questions must be answered.</TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;" width="303"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;" width="180"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: .5pt solid #9BBB59; border-bottom: none; border-left: none;"></TD></TR><TR><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: .5pt solid #9BBB59;">select_one yes_no</TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;">prescrn_q3</TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;" width="371">Does 50% or more of the bank exhibit stratification where at least one layer is erodible material?</TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;" width="173"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;" width="166"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;">yes</TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;" width="228">All 6 BEHI Pre-screening questions must be answered.</TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;" width="303"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;" width="180"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: .5pt solid #9BBB59; border-bottom: none; border-left: none;"></TD></TR><TR><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: .5pt solid #9BBB59;">select_one yes_no</TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;">prescrn_q4</TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;" width="371">Does 50% or more of the bank have a bank height of 10 feet or more with 50% or more soil exposure?</TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;" width="173"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;" width="166"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;">yes</TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;" width="228">All 6 BEHI Pre-screening questions must be answered.</TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;" width="303"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;" width="180"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: .5pt solid #9BBB59; border-bottom: none; border-left: none;"></TD></TR><TR><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: .5pt solid #9BBB59;">select_one yes_no</TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;">prescrn_q5</TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;" width="371">Does 50% or more of the bank exhibit roots lacking bank soil material?</TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;" width="173"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;" width="166"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;">yes</TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;" width="228">All 6 BEHI Pre-screening questions must be answered.</TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;" width="303"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;" width="180"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: .5pt solid #9BBB59; border-bottom: none; border-left: none;"></TD></TR><TR><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: .5pt solid #9BBB59;">select_one yes_no</TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;">prescrn_q6</TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;" width="371">Is 50% or more of the bank void of rooted vegetation?</TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;" width="173"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;" width="166"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;">yes</TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;" width="228">All 6 BEHI Pre-screening questions must be answered.</TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;" width="303"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;" width="180"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: .5pt solid #9BBB59; border-bottom: none; border-left: none;"></TD></TR><TR><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: .5pt solid #9BBB59;">calculate</TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;">q_sum</TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;" width="371">Sum of Questions:</TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;" width="173"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;" width="166"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;" width="228"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;" width="303">${prescrn_q1} != '' and ${prescrn_q2} != '' and ${prescrn_q3} != '' and ${prescrn_q4} != '' and ${prescrn_q5} != '' and ${prescrn_q6} != ''</TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;" width="180">number(${prescrn_q1}) + number(${prescrn_q2}) + number(${prescrn_q3}) + number(${prescrn_q4}) + number(${prescrn_q5}) + number(${prescrn_q6})</TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: .5pt solid #9BBB59; border-bottom: none; border-left: none;"></TD></TR><TR><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: .5pt solid #9BBB59;">text</TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;">behi</TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;" width="371">BEHI:</TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;" width="173"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;" width="166"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;" width="228"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;">yes</TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;" width="303">${prescrn_q1} != '' and ${prescrn_q2} != '' and ${prescrn_q3} != '' and ${prescrn_q4} != '' and ${prescrn_q5} != '' and ${prescrn_q6} != ''</TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;" width="180">if(${q_sum} < 2, 'Low', 'Perform BEHI')</TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none;"></TD><TD style="font-size: 10.0pt; color: black; font-weight: 400; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: .5pt solid #9BBB59; border-bottom: none; border-left: none;"></TD></TR><TR><TD style="font-size: 10.0pt; color: white; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: .5pt solid #9BBB59; background: gray;">end group</TD><TD style="font-size: 10.0pt; color: white; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none; background: gray;"> </TD><TD style="font-size: 10.0pt; color: white; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none; background: gray;" width="371"> </TD><TD style="font-size: 10.0pt; color: white; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none; background: gray;" width="173"> </TD><TD style="font-size: 10.0pt; color: white; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none; background: gray;"> </TD><TD style="font-size: 10.0pt; color: white; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none; background: gray;" width="166"> </TD><TD style="font-size: 10.0pt; color: white; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none; background: gray;"> </TD><TD style="font-size: 10.0pt; color: white; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none; background: gray;" width="228"> </TD><TD style="font-size: 10.0pt; color: white; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none; background: gray;"> </TD><TD style="font-size: 10.0pt; color: white; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none; background: gray;"> </TD><TD style="font-size: 10.0pt; color: white; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none; background: gray;"> </TD><TD style="font-size: 10.0pt; color: white; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none; background: gray;" width="303"> </TD><TD style="font-size: 10.0pt; color: white; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none; background: gray;" width="180"> </TD><TD style="font-size: 10.0pt; color: white; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none; background: gray;"> </TD><TD style="font-size: 10.0pt; color: white; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none; background: gray;"> </TD><TD style="font-size: 10.0pt; color: white; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none; background: gray;"> </TD><TD style="font-size: 10.0pt; color: white; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none; background: gray;"> </TD><TD style="font-size: 10.0pt; color: white; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none; background: gray;"> </TD><TD style="font-size: 10.0pt; color: white; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none; background: gray;"> </TD><TD style="font-size: 10.0pt; color: white; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none; background: gray;"> </TD><TD style="font-size: 10.0pt; color: white; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none; background: gray;"> </TD><TD style="font-size: 10.0pt; color: white; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none; background: gray;"> </TD><TD style="font-size: 10.0pt; color: white; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none; background: gray;"> </TD><TD style="font-size: 10.0pt; color: white; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none; background: gray;"> </TD><TD style="font-size: 10.0pt; color: white; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none; background: gray;"> </TD><TD style="font-size: 10.0pt; color: white; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none; background: gray;"> </TD><TD style="font-size: 10.0pt; color: white; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none; background: gray;"> </TD><TD style="font-size: 10.0pt; color: white; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: none; border-bottom: none; border-left: none; background: gray;"> </TD><TD style="font-size: 10.0pt; color: white; text-decoration: none; border-top: .5pt solid #9BBB59; border-right: .5pt solid #9BBB59; border-bottom: none; border-left: none; background: gray;"> </TD></TR></TBODY></TABLE></BODY></HTML> Thu, 28 Feb 2019 18:30:34 GMT https://community.esri.com/t5/arcgis-survey123-questions/calculate-field-calculating-even-when-question-is/m-p/800276#M10609 LJackson29 2019-02-28T18:30:34Z Re: Calculate field calculating even when question is not relevant https://community.esri.com/t5/arcgis-survey123-questions/calculate-field-calculating-even-when-question-is/m-p/800277#M10610 <HTML><HEAD></HEAD><BODY><P>Hi Leila,</P><P></P><P>Are you able to share your .xlsx so that I can investigate this for you?</P><P></P><P>Brett</P></BODY></HTML> Wed, 06 Mar 2019 02:36:02 GMT https://community.esri.com/t5/arcgis-survey123-questions/calculate-field-calculating-even-when-question-is/m-p/800277#M10610 BrettStokes 2019-03-06T02:36:02Z Re: Calculate field calculating even when question is not relevant https://community.esri.com/t5/arcgis-survey123-questions/calculate-field-calculating-even-when-question-is/m-p/800278#M10611 <HTML><HEAD></HEAD><BODY><P>Hi Brett - I have attached it above. Many thanks!</P></BODY></HTML> Wed, 06 Mar 2019 16:34:13 GMT https://community.esri.com/t5/arcgis-survey123-questions/calculate-field-calculating-even-when-question-is/m-p/800278#M10611 LJackson29 2019-03-06T16:34:13Z Re: Calculate field calculating even when question is not relevant https://community.esri.com/t5/arcgis-survey123-questions/calculate-field-calculating-even-when-question-is/m-p/800279#M10612 <HTML><HEAD></HEAD><BODY><P>I've experienced similar results, and it is a pain, especially if you don't catch it until you've stored thousands of calculated fields that should have never been calculated in the first place. To get around it, I build the relevant into the calculation, with an IF statement. It is a pain, but it does keep you from displaying incomplete calculations.</P><P></P><P>Example:</P><P>if(<EM>${prescrn_q1} != '' and ${prescrn_q2} != '' and ${prescrn_q3} != '' and ${prescrn_q4} != '' and ${prescrn_q5} != '' and ${prescrn_q6} != ''</EM>,number(${prescrn_q1}) + number(${prescrn_q2}) + number(${prescrn_q3}) + number(${prescrn_q4}) + number(${prescrn_q5}) + number(${prescrn_q6}),<STRONG>''</STRONG>)</P></BODY></HTML> Wed, 06 Mar 2019 18:05:20 GMT https://community.esri.com/t5/arcgis-survey123-questions/calculate-field-calculating-even-when-question-is/m-p/800279#M10612 BLove 2019-03-06T18:05:20Z Re: Calculate field calculating even when question is not relevant https://community.esri.com/t5/arcgis-survey123-questions/calculate-field-calculating-even-when-question-is/m-p/800280#M10613 <HTML><HEAD></HEAD><BODY><P>Hi Brian - That did the trick for that field - Many thanks! Unfortunately, I am still encountering the same issue for the next field "Behi". I have tried a variety of different options, the last of which is: </P><P></P><P>if(${q_sum}=0,'Low', if(${q_sum}=1,'Low', if(${q_sum}=2,'Perform BEHI', if(${q_sum}=3,'Perform BEHI', if(${q_sum}=4,'Perform BEHI', if(${q_sum}=5,'Perform BEHI', if(${q_sum}=6,'Perform BEHI', if(string(${q_sum}=''),'N/A', 'N/A'))))))))</P><P></P><P>However, it still returns a response of "Low" when q_sum is null. I am not great with conditional statements, so perhaps there is a better way?</P><P>Thanks!</P><P>Leila</P></BODY></HTML> Tue, 12 Mar 2019 16:43:20 GMT https://community.esri.com/t5/arcgis-survey123-questions/calculate-field-calculating-even-when-question-is/m-p/800280#M10613 LJackson29 2019-03-12T16:43:20Z Re: Calculate field calculating even when question is not relevant https://community.esri.com/t5/arcgis-survey123-questions/calculate-field-calculating-even-when-question-is/m-p/800281#M10614 <HTML><HEAD></HEAD><BODY><P>Hi Leila,</P><P></P><P>Have you tried wrapping another if statement around your entire current if statement, which will return null if <SPAN style="background-color: #ffffff;">q_sum is null, versus at the end, may would work better, or change the order of that statement to be at the start for the null check. I haven't tested either of the below in the app, just created them in notepad++ to see the formatting, but I am hoping one of these should work as you are expecting. You can copy and paste it all onto one line to put into Excel, if that helps, just i like to see it formatted out properly to make sure I have the right number of statements, commas and brackets:</SPAN></P><P></P><PRE class="lia-code-sample line-numbers language-none"><CODE><SPAN class="keyword token">if</SPAN><SPAN class="punctuation token">(</SPAN>${q_sum}<SPAN class="operator token">=</SPAN><SPAN class="string token">''</SPAN> <SPAN class="punctuation token">,</SPAN><SPAN class="string token">'N/A'</SPAN> <SPAN class="punctuation token">,</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="keyword token">if</SPAN><SPAN class="punctuation token">(</SPAN>${q_sum}<SPAN class="operator token">=</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Low'</SPAN> <SPAN class="punctuation token">,</SPAN><SPAN class="keyword token">if</SPAN><SPAN class="punctuation token">(</SPAN>${q_sum}<SPAN class="operator token">=</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Low'</SPAN> <SPAN class="punctuation token">,</SPAN><SPAN class="keyword token">if</SPAN><SPAN class="punctuation token">(</SPAN>${q_sum}<SPAN class="operator token">=</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Perform BEHI'</SPAN> <SPAN class="punctuation token">,</SPAN><SPAN class="keyword token">if</SPAN><SPAN class="punctuation token">(</SPAN>${q_sum}<SPAN class="operator token">=</SPAN><SPAN class="number token">3</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Perform BEHI'</SPAN> <SPAN class="punctuation token">,</SPAN><SPAN class="keyword token">if</SPAN><SPAN class="punctuation token">(</SPAN>${q_sum}<SPAN class="operator token">=</SPAN><SPAN class="number token">4</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Perform BEHI'</SPAN> <SPAN class="punctuation token">,</SPAN><SPAN class="keyword token">if</SPAN><SPAN class="punctuation token">(</SPAN>${q_sum}<SPAN class="operator token">=</SPAN><SPAN class="number token">5</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Perform BEHI'</SPAN> <SPAN class="punctuation token">,</SPAN><SPAN class="keyword token">if</SPAN><SPAN class="punctuation token">(</SPAN>${q_sum}<SPAN class="operator token">=</SPAN><SPAN class="number token">6</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Perform BEHI'</SPAN> <SPAN class="punctuation token">,</SPAN><SPAN class="string token">'N/A'</SPAN> <SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><P></P><P>If that doesn't work try this:</P><P></P><PRE class="lia-code-sample line-numbers language-none"><CODE><SPAN class="keyword token">if</SPAN><SPAN class="punctuation token">(</SPAN>${q_sum}<SPAN class="operator token">=</SPAN><SPAN class="string token">''</SPAN> <SPAN class="punctuation token">,</SPAN><SPAN class="keyword token">if</SPAN><SPAN class="punctuation token">(</SPAN>${q_sum}<SPAN class="operator token">=</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Low'</SPAN> <SPAN class="punctuation token">,</SPAN><SPAN class="keyword token">if</SPAN><SPAN class="punctuation token">(</SPAN>${q_sum}<SPAN class="operator token">=</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Low'</SPAN> <SPAN class="punctuation token">,</SPAN><SPAN class="keyword token">if</SPAN><SPAN class="punctuation token">(</SPAN>${q_sum}<SPAN class="operator token">=</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Perform BEHI'</SPAN> <SPAN class="punctuation token">,</SPAN><SPAN class="keyword token">if</SPAN><SPAN class="punctuation token">(</SPAN>${q_sum}<SPAN class="operator token">=</SPAN><SPAN class="number token">3</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Perform BEHI'</SPAN> <SPAN class="punctuation token">,</SPAN><SPAN class="keyword token">if</SPAN><SPAN class="punctuation token">(</SPAN>${q_sum}<SPAN class="operator token">=</SPAN><SPAN class="number token">4</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Perform BEHI'</SPAN> <SPAN class="punctuation token">,</SPAN><SPAN class="keyword token">if</SPAN><SPAN class="punctuation token">(</SPAN>${q_sum}<SPAN class="operator token">=</SPAN><SPAN class="number token">5</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Perform BEHI'</SPAN> <SPAN class="punctuation token">,</SPAN><SPAN class="keyword token">if</SPAN><SPAN class="punctuation token">(</SPAN>${q_sum}<SPAN class="operator token">=</SPAN><SPAN class="number token">6</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Perform BEHI'</SPAN> <SPAN class="punctuation token">,</SPAN><SPAN class="string token">'N/A'</SPAN> <SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">)</SPAN> <SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><P></P><P>Hope this helps.</P><P>Phil.</P></BODY></HTML> Sun, 12 Dec 2021 09:16:25 GMT https://community.esri.com/t5/arcgis-survey123-questions/calculate-field-calculating-even-when-question-is/m-p/800281#M10614 Anonymous User 2021-12-12T09:16:25Z Re: Calculate field calculating even when question is not relevant https://community.esri.com/t5/arcgis-survey123-questions/calculate-field-calculating-even-when-question-is/m-p/800282#M10615 <HTML><HEAD></HEAD><BODY><P>Hi Phil - This first option worked (didn't bother trying the 2nd option) with a couple tweaks and I changed the response to be null instead of "N/A". Here is the final code: </P><P></P><P><SPAN style="font-size: 10.0pt; color: black;">if(${q_sum}='', '', if(${q_sum}=0,'Low', if(${q_sum}=1,'Low', if(${q_sum}=2,'Perform BEHI', if(${q_sum}=3,'Perform BEHI', if(${q_sum}=4,'Perform BEHI', if(${q_sum}=5,'Perform BEHI',if(${q_sum}=6,'Perform BEHI','N/A') ) ) ) ) ) ) ) </SPAN></P><P></P><P><SPAN style="font-size: 10.0pt; color: black;">Thanks for your help. Just for my edification - why did it make a difference moving the <SPAN>if(${q_sum}='', '',</SPAN><SPAN> to the beginning versus having it at the end?</SPAN></SPAN></P><P><SPAN style="font-size: 10.0pt; color: black;"></SPAN></P><P><SPAN style="font-size: 10.0pt; color: black;"><SPAN>Best,</SPAN></SPAN></P><P><SPAN style="font-size: 10.0pt; color: black;"><SPAN>Leila</SPAN></SPAN></P></BODY></HTML> Wed, 13 Mar 2019 15:23:02 GMT https://community.esri.com/t5/arcgis-survey123-questions/calculate-field-calculating-even-when-question-is/m-p/800282#M10615 LJackson29 2019-03-13T15:23:02Z Re: Calculate field calculating even when question is not relevant https://community.esri.com/t5/arcgis-survey123-questions/calculate-field-calculating-even-when-question-is/m-p/800283#M10616 <HTML><HEAD></HEAD><BODY><P>Hi Leila,</P><P></P><P>Great it worked. The reason I think it worked after moving the order around is that I also compiled the if statement slightly differently (arguments, commas and brackets are in slightly different place to your original statement). The first part deals with what happens when null the second part deals with everything else, ie if "nulll" then "null" otherwise "run the next set of nested if statements if a value exists". The way you had it before it was trying to do the value and null expression all a part of the same nested if statement.</P><P></P><P>Phil.</P></BODY></HTML> Wed, 13 Mar 2019 22:07:40 GMT https://community.esri.com/t5/arcgis-survey123-questions/calculate-field-calculating-even-when-question-is/m-p/800283#M10616 Anonymous User 2019-03-13T22:07:40Z