Hey @Jellow ! ![]()
I've implemented the logic for you - please find the XLSForm and a short demo below!
Based on your post, I realized that you need two different types of sums here:
- Cumulative sum for a specific picker within a repeat instance, which updates as more instances for the same picker are added within the same repeat group.
- Overall sum that can be displayed at the end.
I have to admit, this one was quite complex! I even had to revisit ODK’s documentation after a long time to implement this one. But here’s the secret sauce that made it work: [XPath Predicates For Filtering] - buried deep within the documentation!

EachPickerSum.xlsx (11.9 KB)
Hope this helps! Wishing you a great day! ![]()