AnsweredAssumed Answered

Addition operand in Survey123 XLS form

Question asked by edzlonis on Jul 19, 2016
Latest reply on Jul 22, 2016 by rowright

Addition operand in math formula results in concatenation rather than sum for numeric
values.  I am trying to sum 4 previous fields to confirm that they add up
to 1.0. The following formula ${EC} + ${FLC} + ${OWC} + ${ShC} results in a
concatenation (0.40.30.20.1), rather than a sum (1.0) of the fields. The other
operands all work correctly. In the Excel spreadsheet the name cells for the
select_one field (e.g., PropCover) are defined as numeric and the type for the
recipient cell (TotalCover) is decimal. When I use the form with this formula
in ODK Collector the addition operand works correctly. Am I missing something?
Thanks.

Outcomes