Hello-
I have a survey that calculates a final score depending on what violations are checked.
The inspection begins with 100 pts. If a box is checked for a violation, points ae deducted.
The calculations are working fine but the user wants a trigger for 'Fail' if the score goes below 90 pts.
Line 203 has my attempt at a calculation but I am missing something.
I have a lot to learn.
Thanks for any help.
Solved! Go to Solution.
You will want to change the question type to "text", but something like this should work.
if(${final_score } < 90, 'FAIL','PASS')
See the description of the if function in the documentation below.
https://doc.arcgis.com/en/survey123/desktop/create-surveys/xlsformformulas.htm
You will want to change the question type to "text", but something like this should work.
if(${final_score } < 90, 'FAIL','PASS')
See the description of the if function in the documentation below.
https://doc.arcgis.com/en/survey123/desktop/create-surveys/xlsformformulas.htm