Incorrect calculation in a repeat?

08-28-2018 07:08 AM
New Contributor

With the same calculation formula, Survey123 is giving me different results.  Below is a screenshot of my xlsform showing my calculation for the intercept field.

Survey123 Excel

This one shows the correct calculation for intercept field. 

Right calculation

The incorrect calculation shown below.  The intercept number should be 0.7 not 0.69.

Wrong Calculation

0 Kudos
1 Reply
Occasional Contributor

The sum function in this repeat will sum all the transect together. I believe this is why you are getting different answers. 

0 Kudos