Select to view content in your preferred language

Scoring

231
1
Jump to solution
3 weeks ago
SueBoelk2
Occasional Contributor

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.

0 Kudos
1 Solution

Accepted Solutions
Neal_t_k
Frequent Contributor

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

View solution in original post

1 Reply
Neal_t_k
Frequent Contributor

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