| type | name | label | calculation | default |
|---|
| integer | total_repeats | Number Repeats | count(${dummy_counter}) | |
| decimal | mean_veg | Average | round(sum(${num_veg}) div ${total_repeats},2) | |
| | | | |
| begin repeat | quads | Quad Data Entry | | |
| hidden | dummy_counter | incraments repeat count | 1 | |
| integer | num_veg | # Vegetative | | 0 |
| decimal | num_veg_sqdif | Sq Difference Veg | pow((${num_veg} - ${mean_veg}),2) | 0 |
| end repeat | | | | |
A portion of the XLS form is above, the problem is that the num_veg_sqdif doesn't automatically re-calculate after new repeat records are added. Notice how the calculation uses the mean of all values inside the repeat. This mean value changes when a new repeat is added, thus all previously calculated num_veg_sqdif values need to be re-calculated.
The only way to do that is to manually page back through the repeat records and hit the arrow button (looks like the recycle symbol) on the num_veg_sqdif field.
The survey123 docs say this: "Unlike the default column, which is evaluated only when the survey is opened or the question becomes relevant, calculations are evaluated every time answers in your survey that are inputs to the calculation change or become relevant."
Why isn't the re-calculation happening inside the repeat, is this expected behavior?
BTW: this entire post would be a moot point if there were a few more aggregation functions that work with repeats, submitted idea here: https://community.esri.com/ideas/16449
