Problem using the sum aggregation function

Question

Hi,

I want to check that 2 specific choices have been selected for 2 items inside a repeat. I thought about using the sum aggregation function to do that, assigning a value to both choices and putting a constraint on the sum.

Unfortunately, the sum result gives me 12 when I was expecting 3. The values 1 and 2 are concatenated instead of being added.

See attached form.

Test Calculation.xlsx

JamesTedrick · Accepted Answer

Hi Olivier,

seelct_one questions by default are strings, so the summation would normally be a concatenation.  Normally, this can be altered by setting the bind::type column to integer - bind::type controls the type of value in the form.  However, I'm seeing issues validating a form with a select_one in a repeat to a different type.  The workaround would be to create a calculate question with the value that is set to the correct type (they default to strings as well), and use that for the calculation (see attached).