topic Re: Calculating using decimals in ArcGIS Survey123 Questions

Calculating using decimals

JohnPlunkett — Tue, 21 Feb 2017 01:06:46 GMT

Hi there

Working with a customer we sometimes need to do a calculation for example

pow((${BasalDiameter} *50),.42)*.66

However this fails when we view in Survey123 Connect

- Changing the calculation so that there is a leading Zero it works as expected. - Is this a known issue?

pow((${BasalDiameter} *50),.042)*0.66

Edit- using Survey123 Connect 1.10.43 Windows 10

DanPatterson_Retired — Tue, 21 Feb 2017 01:11:33 GMT

what about spaces... pow((${BasalDiameter} * 50), .42) * .66

I would use preceding 0's and spaces around operands in any case

JohnPlunkett — Tue, 21 Feb 2017 01:18:05 GMT

Hi Dan

Thanks for your response - unfortunately using spaces doesn't work - it appears that you need to have preceding 0's to make it work

DanPatterson_Retired — Tue, 21 Feb 2017 01:21:28 GMT

some 'languages' are more fussy than others I suspect

MitchellProctor — Tue, 21 Feb 2017 04:41:49 GMT

Hi John,

I see you've already figured this out, but yes, leading zeroes are needed to make decimal calculations work, and this is expected behavior.