topic Conditional Calculations Logic? in ArcGIS Survey123 Questions https://community.esri.com/t5/arcgis-survey123-questions/conditional-calculations-logic/m-p/789550#M7939 <HTML><HEAD></HEAD><BODY><P>I have a field that I'm calculating based off inputs from other fields. If a tree is dead, it gets a score of 8. If a tree isn't dead, then the score is calculated by adding two other values together. I have written:</P><P></P><P>if(selected(${Dead_Tree},'yes'),8,''),if(selected(${Dead_Tree},'no'),'int(${Highest_Potential})+int(${Total_Failure})','')</P><P></P><P>However I keep getting "bad node" errors. How do I write the proper expression?</P></BODY></HTML> Thu, 13 Dec 2018 17:30:11 GMT deleted-user-jxpbpbjlZInj 2018-12-13T17:30:11Z Conditional Calculations Logic? https://community.esri.com/t5/arcgis-survey123-questions/conditional-calculations-logic/m-p/789550#M7939 <HTML><HEAD></HEAD><BODY><P>I have a field that I'm calculating based off inputs from other fields. If a tree is dead, it gets a score of 8. If a tree isn't dead, then the score is calculated by adding two other values together. I have written:</P><P></P><P>if(selected(${Dead_Tree},'yes'),8,''),if(selected(${Dead_Tree},'no'),'int(${Highest_Potential})+int(${Total_Failure})','')</P><P></P><P>However I keep getting "bad node" errors. How do I write the proper expression?</P></BODY></HTML> Thu, 13 Dec 2018 17:30:11 GMT https://community.esri.com/t5/arcgis-survey123-questions/conditional-calculations-logic/m-p/789550#M7939 deleted-user-jxpbpbjlZInj 2018-12-13T17:30:11Z Re: Conditional Calculations Logic? https://community.esri.com/t5/arcgis-survey123-questions/conditional-calculations-logic/m-p/789551#M7940 <HTML><HEAD></HEAD><BODY><P>Ok after more trial and error, I seem to have gotten the result I was looking for with the following forumla:</P><P></P><P>if(selected(${Dead_Tree},'yes'),8,((${Highest_Pot_Score})+(${Total_Fail_Potent})))</P></BODY></HTML> Thu, 13 Dec 2018 18:37:13 GMT https://community.esri.com/t5/arcgis-survey123-questions/conditional-calculations-logic/m-p/789551#M7940 deleted-user-jxpbpbjlZInj 2018-12-13T18:37:13Z