AnsweredAssumed Answered

Conditional Calculation

Question asked by Chris.anderson on Mar 12, 2019
Latest reply on Mar 12, 2019 by dougbrowning

I am working on  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.

 

Is there another way of working this problem? I want to keep the number of extra/junk columns to a minimum.

 

Any help you can provide is greatly appreciated.

Chris Anderson

Florida Fish and Wildlife Conservation Commission

Outcomes