AnsweredAssumed Answered

Repeat aggregate function  - blank repeat values

Question asked by woodster5 on Mar 10, 2020
Latest reply on Apr 1, 2020 by Philip.Wilson-esristaff


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?





Partly related to issue: Bug with repeat aggregate function?