# Conditional Calculation

49
1
03-12-2019 11:29 AM Occasional Contributor

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

1 Reply by MVP Frequent Contributor

You can for sure use if in a calculation.  My guess is that B and C are strings.  If so use concat(a,b) - + won't do it. 