Conditional Calculation

49
1
03-12-2019 11:29 AM
ChrisAnderson4
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

0 Kudos
1 Reply
DougBrowning
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.

0 Kudos