How do I Sum the count of a list in a repeating group

[cyriltdixon]

Hi bubblers, how do I sum the counts I have done in a repeating group within a repeating group. I want to sum the insights total across each cell?
Thanks

[Bruno27]

you can use a group, set it and data type number and than refer to each repeating groups within the new group where you are counting and adding a plus sign for each count!

[cyriltdixon]

Thanks @Bruno27 the group part makes sense but i’m struggling with the expression to sum them in the repeating group?

[cmarchan]

@cyriltdixon

Add a field of type number to the intervention object (… in Bubblish … a data type). Call it articlesCount. Every time you add an article update this field with the total count of articles for that intervention.

After that you can use an expression in any text element or group (make the type to be number) like this > repeating group interventions articlesCount :sum

The above assumes that your rg is of type intervention and it’s data source is a search for interventions

[Bruno27]

yes then try what @cmarchan suggested or share your editor and i will have a look:)

[cyriltdixon]

Sorted, thanks @Bruno27 Legend!