topic Re: Conditional Calculation in ArcGIS Survey123 Questions https://community.esri.com/t5/arcgis-survey123-questions/conditional-calculation/m-p/858205#M25236 <HTML><HEAD></HEAD><BODY><P>You can for sure use if in a calculation.&nbsp; My guess is that B and C are strings.&nbsp; If so use concat(a,b) - + won't do it.</P></BODY></HTML> Tue, 12 Mar 2019 19:42:41 GMT DougBrowning 2019-03-12T19:42:41Z Conditional Calculation https://community.esri.com/t5/arcgis-survey123-questions/conditional-calculation/m-p/858204#M25235 <HTML><HEAD></HEAD><BODY><P>I am working on&nbsp; survey where I would like to have a conditional calculation depending upon a question's answer. Simply put, if the user answers question A, ${A}, with "yes", they answer question B, ${B}; if "no",they answer question C, ${C}. Later, I want to create a confirmation number that, depending upon the value of ${A}, includes ${B} or ${C} (and some additional values in ${D}). I am trying to use the If(condition,x,y) to create the calculation If(${A}='Yes',${B}+${D}, ${C}+$D}). I am getting an error saying the calculation cannot use "If" function.</P><P></P><P>Is there another way of working this problem? I want to keep the number of extra/junk columns to a minimum.</P><P></P><P>Any help you can provide is greatly appreciated.</P><P>Chris Anderson</P><P>Florida Fish and Wildlife Conservation Commission</P></BODY></HTML> Tue, 12 Mar 2019 18:29:53 GMT https://community.esri.com/t5/arcgis-survey123-questions/conditional-calculation/m-p/858204#M25235 Chris_Anderson 2019-03-12T18:29:53Z Re: Conditional Calculation https://community.esri.com/t5/arcgis-survey123-questions/conditional-calculation/m-p/858205#M25236 <HTML><HEAD></HEAD><BODY><P>You can for sure use if in a calculation.&nbsp; My guess is that B and C are strings.&nbsp; If so use concat(a,b) - + won't do it.</P></BODY></HTML> Tue, 12 Mar 2019 19:42:41 GMT https://community.esri.com/t5/arcgis-survey123-questions/conditional-calculation/m-p/858205#M25236 DougBrowning 2019-03-12T19:42:41Z