nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Complex if/else statements in Survey123

Anonymous User

Hi, I am trying to calculate a complex if/else statement with several ands and ors. I keep getting an error with inbalanced brackets but cannot figure it out. Any help appreciated!

Statement:

if(selected(${OutletGradeId},'At Stream Grade'),'Full AOP', if(selected(${InletGradeId},'Free Fall') and ${OutletDropToWaterSurface} > 1 and ${OUTLETGRADEDIVIDED} > 0.5 ),'No AOP',if(selected(${OutletGradeId},'Free Fall onto Cascade' ) and ${OutletDropToWaterSurface} > 1 and ${OUTLETGRADEDIVIDED} > 0.5 ),'No AOP',if(selected(${OutletGradeId},'Cascade') and ${OutletDropToWaterSurface} > 1 and ${OUTLETGRADEDIVIDED} > 0.5 ),'No AOP',),'Reduced AOP','NULL')))))

Thank you!

Encuentra más publicaciones etiquetadas con

Accepted answers

KassandraRodriguez

<SPAN class="keyword token">if</SPAN><SPAN class="punctuation token">(</SPAN>selected<SPAN class="punctuation token">(</SPAN>$<SPAN class="punctuation token">{</SPAN>OutletGradeId<SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'At Stream Grade'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Full AOP'</SPAN><SPAN class="punctuation token">,</SPAN>

<SPAN class="keyword token">if</SPAN><SPAN class="punctuation token">(</SPAN>selected<SPAN class="punctuation token">(</SPAN>$<SPAN class="punctuation token">{</SPAN>InletGradeId<SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Free Fall'</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">and</SPAN> $<SPAN class="punctuation token">{</SPAN>OutletDropToWaterSurface<SPAN class="punctuation token">}</SPAN> <SPAN class="operator token">></SPAN> <SPAN class="number token">1</SPAN> <SPAN class="operator token">and</SPAN> $<SPAN class="punctuation token">{</SPAN>OUTLETGRADEDIVIDED<SPAN class="punctuation token">}</SPAN> <SPAN class="operator token">></SPAN> <SPAN class="number token">0.5</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'No AOP'</SPAN><SPAN class="punctuation token">,</SPAN> 

<SPAN class="keyword token">if</SPAN><SPAN class="punctuation token">(</SPAN>selected<SPAN class="punctuation token">(</SPAN>$<SPAN class="punctuation token">{</SPAN>OutletGradeId<SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Free Fall onto Cascade'</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">and</SPAN> $<SPAN class="punctuation token">{</SPAN>OutletDropToWaterSurface<SPAN class="punctuation token">}</SPAN> <SPAN class="operator token">></SPAN> <SPAN class="number token">1</SPAN> <SPAN class="operator token">and</SPAN> $<SPAN class="punctuation token">{</SPAN>OUTLETGRADEDIVIDED<SPAN class="punctuation token">}</SPAN> <SPAN class="operator token">></SPAN> <SPAN class="number token">0.5</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'No AOP'</SPAN><SPAN class="punctuation token">,</SPAN> 

<SPAN class="keyword token">if</SPAN><SPAN class="punctuation token">(</SPAN>selected<SPAN class="punctuation token">(</SPAN>$<SPAN class="punctuation token">{</SPAN>OutletGradeId<SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Cascade'</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">and</SPAN> $<SPAN class="punctuation token">{</SPAN>OutletDropToWaterSurface<SPAN class="punctuation token">}</SPAN> <SPAN class="operator token">></SPAN> <SPAN class="number token">1</SPAN> <SPAN class="operator token">and</SPAN> $<SPAN class="punctuation token">{</SPAN>OUTLETGRADEDIVIDED<SPAN class="punctuation token">}</SPAN> <SPAN class="operator token">></SPAN> <SPAN class="number token">0.5</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'No AOP'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Reduced AOP'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'NULL'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

I broke it down so that it's easier to see, So I think your error is at the last if statement it can either be 'No AOP' or 'Reduced AOP' cant be both so you'll have to write another if statement if you want to include the other one. Also I removed unnecessary brackets.

All comments

Anonymous User

Thank you! It is not a select field unfortunately. I think the issue is

that ALL of those have to be true to get No Barrier otherwise it gets

reduced AOP or null if any of those fields has a null. Does your second

option work here or would that give “No barrier” if any of them are true?

Thank you again!

On Thu, Jan 16, 2020 at 12:43 PM Kassandra Rodriguez <geonet@esri.com>

KassandraRodriguez

<SPAN class="keyword token">if</SPAN><SPAN class="punctuation token">(</SPAN>$<SPAN class="punctuation token">{</SPAN>INLETGRADESCORE<SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Full AOP'</SPAN> <SPAN class="operator token">and</SPAN> $<SPAN class="punctuation token">{</SPAN>OUTLETGRADESCORE<SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Full AOP'</SPAN> <SPAN class="operator token">and</SPAN> $<SPAN class="punctuation token">{</SPAN>DEPTHSCORE<SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Full AOP'</SPAN> <SPAN class="operator token">and</SPAN> $<SPAN class="punctuation token">{</SPAN>SUBSTRATEMATCHSCORE<SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Full AOP'</SPAN> <SPAN class="operator token">and</SPAN> $<SPAN class="punctuation token">{</SPAN>SUBSTRATECOVERSCORE<SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Full AOP'</SPAN> <SPAN class="operator token">and</SPAN> $<SPAN class="punctuation token">{</SPAN>PHYSBARRSCORE<SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Full AOP'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'No Barrier'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Reduced AOP'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'NULL'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

Hmmm I'm not sure what the argument is here but I think you meant to use "if(selected(" ? If not take a look at my example below:

<SPAN class="keyword token">if</SPAN><SPAN class="punctuation token">(</SPAN>$<SPAN class="punctuation token">{</SPAN>COUNTY<SPAN class="punctuation token">}</SPAN> <SPAN class="operator token">=</SPAN> <SPAN class="string token">'PLA'</SPAN> <SPAN class="operator token">and</SPAN> $<SPAN class="punctuation token">{</SPAN>ROUTE<SPAN class="punctuation token">}</SPAN><SPAN class="operator token">=</SPAN><SPAN class="string token">'65'</SPAN> <SPAN class="operator token">and</SPAN> $<SPAN class="punctuation token">{</SPAN>EndPM<SPAN class="punctuation token">}</SPAN> <SPAN class="operator token"><=</SPAN> <SPAN class="number token">12.5</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Marcy Pillett'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'N/A'</SPAN><SPAN class="punctuation token">)</SPAN>‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

Mine has one answer if the argument is met which is 'Marcy Pillet' if it's not met then it's 'N/A'. Yours has too many answers. What I think you meant to do is

<SPAN class="keyword token">if</SPAN><SPAN class="punctuation token">(</SPAN>$<SPAN class="punctuation token">{</SPAN>INLETGRADESCORE<SPAN class="punctuation token">}</SPAN> <SPAN class="operator token">=</SPAN> <SPAN class="string token">'Full AOP'</SPAN> <SPAN class="operator token">and</SPAN> $<SPAN class="punctuation token">{</SPAN>OUTLETGRADESCORE<SPAN class="punctuation token">}</SPAN> <SPAN class="operator token">=</SPAN> <SPAN class="string token">'Full AOP'</SPAN> <SPAN class="operator token">and</SPAN> $<SPAN class="punctuation token">{</SPAN>DEPTHSCORE<SPAN class="punctuation token">}</SPAN> <SPAN class="operator token">=</SPAN> <SPAN class="string token">'Full AOP'</SPAN> <SPAN class="operator token">and</SPAN> $<SPAN class="punctuation token">{</SPAN>SUBSTRATEMATCHSCORE<SPAN class="punctuation token">}</SPAN> <SPAN class="operator token">=</SPAN><SPAN class="string token">'Full AOP'</SPAN> <SPAN class="operator token">and</SPAN> $<SPAN class="punctuation token">{</SPAN>SUBSTRATECOVERSCORE<SPAN class="punctuation token">}</SPAN> <SPAN class="operator token">=</SPAN> <SPAN class="string token">'Full AOP'</SPAN> <SPAN class="operator token">and</SPAN> $<SPAN class="punctuation token">{</SPAN>PHYSBARRSCORE<SPAN class="punctuation token">}</SPAN> <SPAN class="operator token">=</SPAN> <SPAN class="string token">'Full AOP'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'No Barrier'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'NULL'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

So the answer if the argument is met would be 'No Barrier' otherwise if it's not met it's 'NULL'. Also notice the syntax is different from "if selected" I used equals sign.

Anonymous User

I went through and corrected all of my other calculations based on your advce and have just one left that is stumping me: if(${INLETGRADESCORE},'Full AOP' and ${OUTLETGRADESCORE}, 'Full AOP' and ${DEPTHSCORE},'Full AOP' and ${SUBSTRATEMATCHSCORE},'Full AOP' and ${SUBSTRATECOVERSCORE},'Full AOP' and ${PHYSBARRSCORE},'Full AOP','No Barrier', 'Reduced AOP', 'NULL')

This one says "something broke the parser, if requires 3 arguments, only 10 provided"

I've tried all number of combinations I could think of.

Any ideas?

Thank you!

Anonymous User

Thank you! That worked!

KassandraRodriguez

<SPAN class="keyword token">if</SPAN><SPAN class="punctuation token">(</SPAN>selected<SPAN class="punctuation token">(</SPAN>$<SPAN class="punctuation token">{</SPAN>OutletGradeId<SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'At Stream Grade'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Full AOP'</SPAN><SPAN class="punctuation token">,</SPAN>

<SPAN class="keyword token">if</SPAN><SPAN class="punctuation token">(</SPAN>selected<SPAN class="punctuation token">(</SPAN>$<SPAN class="punctuation token">{</SPAN>InletGradeId<SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Free Fall'</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">and</SPAN> $<SPAN class="punctuation token">{</SPAN>OutletDropToWaterSurface<SPAN class="punctuation token">}</SPAN> <SPAN class="operator token">></SPAN> <SPAN class="number token">1</SPAN> <SPAN class="operator token">and</SPAN> $<SPAN class="punctuation token">{</SPAN>OUTLETGRADEDIVIDED<SPAN class="punctuation token">}</SPAN> <SPAN class="operator token">></SPAN> <SPAN class="number token">0.5</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'No AOP'</SPAN><SPAN class="punctuation token">,</SPAN> 

<SPAN class="keyword token">if</SPAN><SPAN class="punctuation token">(</SPAN>selected<SPAN class="punctuation token">(</SPAN>$<SPAN class="punctuation token">{</SPAN>OutletGradeId<SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Free Fall onto Cascade'</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">and</SPAN> $<SPAN class="punctuation token">{</SPAN>OutletDropToWaterSurface<SPAN class="punctuation token">}</SPAN> <SPAN class="operator token">></SPAN> <SPAN class="number token">1</SPAN> <SPAN class="operator token">and</SPAN> $<SPAN class="punctuation token">{</SPAN>OUTLETGRADEDIVIDED<SPAN class="punctuation token">}</SPAN> <SPAN class="operator token">></SPAN> <SPAN class="number token">0.5</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'No AOP'</SPAN><SPAN class="punctuation token">,</SPAN> 

<SPAN class="keyword token">if</SPAN><SPAN class="punctuation token">(</SPAN>selected<SPAN class="punctuation token">(</SPAN>$<SPAN class="punctuation token">{</SPAN>OutletGradeId<SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Cascade'</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">and</SPAN> $<SPAN class="punctuation token">{</SPAN>OutletDropToWaterSurface<SPAN class="punctuation token">}</SPAN> <SPAN class="operator token">></SPAN> <SPAN class="number token">1</SPAN> <SPAN class="operator token">and</SPAN> $<SPAN class="punctuation token">{</SPAN>OUTLETGRADEDIVIDED<SPAN class="punctuation token">}</SPAN> <SPAN class="operator token">></SPAN> <SPAN class="number token">0.5</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'No AOP'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Reduced AOP'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'NULL'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Únete a la Conversación

Los miembros registrados pueden publicar, seguir actualizaciones y más. ¿Nuevo aquí? Regístrate gratis.

Enlaces Rápidos

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.