Hi,
I’ve figured out what the problem is. In order to use the aggregate function, sum(${repeat_value}), the values in the repeat had to be converted to integers in separate fields using ‘number(${field})’. These new columns were hidden using a ‘relevant’ clause. However, this no longer works as the calculation no longer was being evaluated where the column is not relevant.
I have changed these hidden fields to ‘hidden’ types, removed the ‘relevant’ clause, added ind:esriFieldType as esriFieldTypeInteger and added a column called ‘bind::type’ and set to ‘int’. This now appears to work.
Claire