Hi,
I have an issue with the repeat aggregate function in relation to repeats.
My survey uses repeats, and sums the total within each repeat using the aggregate function e.g. sum(${repeat_value}). Each of these totals is then summed in a single calculation e.g. sum(${repeat_value1})+sum(${repeat_value2})+sum(${repeat_value3}).
However, in Connect version 3.7.62 and Survey123 v. 3.7.57, a record is no longer automatically created within a repeat, hence the formula above no longer works, unless a blank record is created in the repeats. This is OK in some instances (we just need to make sure users add a record in the repeat), but in some scenarios, the repeat is hidden because it is not relevant.
So, is there a way of automatically creating a record in a repeat?
Or is there a work around to get the formula above to work in order to sum all values in a set of repeats?
Thanks!
Claire
Partly related to issue: https://community.esri.com/thread/214756-bug-with-repeat-aggregate-function
