Calculation not working in Survey123

103
2
02-25-2020 02:10 AM
Castle_HeadFSC
New Contributor

I have a multiplication calculation multiplying the answers to three select_one questions together. I (think!) I have set the bind::types right to make sure everything is treated as an integer. I get a number out of the calculation but it is orders of magnitudes off. For example it is calculating 2 x 20 x 10 as 13968240. Not sure how to fix it. I've tried doing the calculation under the calculate 'type' and as an interger 'type'. Relevant rows are highlighted. 

Any help would be much appreciated!

0 Kudos
2 Replies
DougBrowning
MVP Frequent Contributor

Try setting the bind::type field for the 3 fields going into the calculation not just the answer field.  I see you use the bind::esri one here instead.  Try to set all of them in bind::type to int.

0 Kudos
markdynge
New Contributor III

castle head, using a calculator 222*242*260 equals number you gave, the calculations are done on the name column of your select_one list not the label. I end up giving the name and the title columns the same value so the forms display correctly and the math works out as expected

pic of choices page