Sum() over calculate'ed values assumes they are Strings and concatenates

JoseVidal

 

In this simple survey:

 

type	name	label	calculation
begin repeat	group1	Group 1
decimal	repeated_decimal	Repeated Decimal Number
calculate	calculated_decimal		number(${repeated_decimal})
end repeat
decimal	sum_of_decimal	Sum of Decimal	round(sum(${calculated_decimal}),2)

 

the sum_of_decimal value ends up being the concatenation of the repeated_decimals, not the mathematical sum. It works OK if we sum() over repeated_decimal, but sum() assumes they are strings if over calculated_decimal

I tried adding number() in various places in the calculations, to no avail.

 

dougbrowning

Ok you kinda lost me so I am attaching a sheet that shows you how.  You just need to set the bind type column to decimal.  Everything is a string while in 123 really until it uploads.  I know this sounds weird.  So you need to tell 123 to treat it as a decimal while in the form.  That is why it is doing a concat.

Edit :  Use a note to get around the refresh thing.  Then if you want the final value to store as a decimal use the bind esri field.  

See attached.

Test Sum.xlsx