topic Re: Mismatched Brackets in ArcGIS Survey123 Questions

Mismatched Brackets

SamThach — Mon, 06 Jun 2022 19:52:41 GMT

I am writing a calculation for a bunch of variables and keep getting the error about mismatched brackets. I do not see what is wrong since I count that all brackets are there in the right spots. Anybody know what is wrong? I tried this into a simpler one located down below but got the same error.

original:

IF(selected(${sidewalk},"yes"), (int(${obscured_adress}) + int(${broken_windows}) + int(${yard_debris}) + int(${untrimmed_yard}) + int(${roofing_cond}) + int(${paint_exterior_cond}) + int(${physical_appearance}) + int(${sidewalk_kind})) , (int(${obscured_adress}) + int(${broken_windows}) + int(${yard_debris}) + int(${untrimmed_yard}) + int(${roofing_cond}) + int(${paint_exterior_cond}) + int(${physical_appearance}))

simpler test:

IF(selected(${sidewalk},"yes"), 1, 0)

Re: Mismatched Brackets

DougBrowning — Mon, 06 Jun 2022 19:56:51 GMT

Did you try if it may be case sensitive and not know what IF means. Just a guess.

Re: Mismatched Brackets

RobertBorchert — Mon, 06 Jun 2022 20:04:17 GMT

You have 19 start ( and only 18 closing )

Trouble shooing Tip paste it into Word and use the search function to count the number of each.

Re: Mismatched Brackets

IsmaelChivite — Mon, 06 Jun 2022 20:59:24 GMT

This works for me. I just added an extra parenthesis at the end and replaced IF with if

if(selected(${sidewalk},"yes"), (int(${obscured_adress}) + int(${broken_windows}) + int(${yard_debris}) + int(${untrimmed_yard}) + int(${roofing_cond}) + int(${paint_exterior_cond}) + int(${physical_appearance}) + int(${sidewalk_kind})) , (int(${obscured_adress}) + int(${broken_windows}) + int(${yard_debris}) + int(${untrimmed_yard}) + int(${roofing_cond}) + int(${paint_exterior_cond}) + int(${physical_appearance})))

Attaching another approach to do this

Re: Mismatched Brackets

DeonLengton — Tue, 07 Jun 2022 09:10:05 GMT

Better yet, use Notepad++

If you highlight a bracket it will show its closing bracket, if it exists...