topic Re: 'if' Statement Arguments Error in ArcGIS Survey123 Questions

'if' Statement Arguments Error

HanggarPrasetio1 — Wed, 07 Feb 2024 03:16:59 GMT

Hi, I have a conditional statement calculation in my survey in that is returning an error:

"XPath evaluation: cannot handle function 'if' requires 3 arguments, Only 2 provided."

As you can see , so I am stumped. Your input is much appreciated.

if(selected(${JenisPelanggaran},'1'),'Alat Tangkap', if(selected(${JenisPelanggaran},'2'),'Biota Dilindungi', if(selected(${JenisPelanggaran},'3'),'Destruktif/ Merusak', if(selected(${JenisPelanggaran},'4'),'Habitat Penting', if(selected(${JenisPelanggaran},'5'),'IUU Fishing', if(selected(${JenisPelanggaran},'6'),'Jasa Lingkungan (TLPJL)', if(selected(${JenisPelanggaran},'7'),'Pengrusakan Terumbu Karang', if(selected(${JenisPelanggaran},'8'),'Pengrusakan Padang Lamun', if(selected(${JenisPelanggaran},'9'),'Pengrusakan Mangrove', if(selected(${JenisPelanggaran},'10'),'SOP Pemanfaatan', if(selected(${JenisPelanggaran},'11'),'Zonasi')))))))))))

Re: 'if' Statement Arguments Error

ChrisUnderwood — Wed, 07 Feb 2024 11:43:15 GMT

Hello @HanggarPrasetio1 , is your last expression missing a value for when the condition is False ?

Something like :

if(selected(${JenisPelanggaran},'11'),'Zonasi','None of the above'

This post has an example

https://community.esri.com/t5/arcgis-survey123-questions/survey123-calculation-multiple-if-parameters/td-p/1039576

if(condition, value if true,
if(condition, value if true,
if(condition, value if true,
if(condition, value if true,
if(condition, value if true, value if false)))))

Re: 'if' Statement Arguments Error

abureaux — Wed, 07 Feb 2024 21:27:16 GMT

Helpful tip for S123. While the formulas in the XLSX sheet are NOT Excel compatible, Excel will still give you the "helper" features if you add in "=" in front of the formula.

To do this and check your formula:

Write a S123 formula and press enter (i.e., just exit the cell)
Click back into the cell, and add "=" to the start
You will now see color-coded brackets. Also, if you use the arrow keys to scroll over brackets, the matching brackets will be highlighted. And finally, you also get to take advantage of Excel's logic guide:
1. Without going into too many specifics, you can use this mode to check for balanced brackets and proper formula set-up. E.g., You should only see a single "white" bracket at the end of any nested IF statement. If you see more than one, you have unbalanced brackets
Be sure to delete the "=" before saving the XLSX or you will get an error.