Calculating using decimals

[JohnPlunkett]

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]

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

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

[JohnPlunkett · Accepted solution]

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]

some 'languages' are more fussy than others I suspect

[MitchellProctor]

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.