If Condition with Result

Support
,
1

Hello,

I am working on an XLSForm where I want to calculate the percentage of correct answers and categorize the result into three levels: High, Medium, and Low using the if() function in a calculation. However, when I upload the form to ODK Validate or XLSForm Online, I get an error saying: "Couldn't understand the expression."

Could you please help me by sharing a correct example or guide me on how to properly write this calculation?

Thank you very much for your support.

Best regards,
Faisal Amani
natija.xlsx (11.4 KB)

2

Hi, try:

if(${correct} >= 75, 'عالی / لوړه درجه', if(${correct} >= 50, 'متوسط / منځنۍ درجه', 'ضعیف / ټیټه درجه'))
1 Like