Scoring

Question

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.

Upd_Dairy Inspection.xlsx

ArchLogo.jpg

Neal_t_k · Accepted Answer

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