How to SUM a field in repeat by conditional selected field?

796
6
01-16-2020 12:25 PM
GeoprocessamentoCerradinho
New Contributor III

Need to total the volumes reported in the repeater by product in "insumo" field. 


In the same form I can have in the repeater several inclusions of the limestone product (named "insumo"), in addition to the inclusion of other products such as phosphate. I need to total each at the end, but I am unable to persist the sum of each product in its respective note. Similar logic to excel sumif.

0 Kudos
6 Replies
KassandraRodriguez
Occasional Contributor

Have you tried putting the 'if selected' in the relevant column instead?

*Sorry change the 'if selected' to 'selected' in the relevant column

0 Kudos
GeoprocessamentoCerradinho
New Contributor III


Sorry, I didn't understand how relevant column could help me do the summation. I do not want to skip any of the fields, but bring the sum of each product ("insumo" field) on their respective note.

0 Kudos
KassandraRodriguez
Occasional Contributor
GeoprocessamentoCerradinho
New Contributor III

Thank you for your attention, in the article the sum is performed on all records regardless of category. Interestingly it seems that when storing the data the sum is separated by category. I don't know if there is a way to retrieve this sum in a note field.

0 Kudos
KimberlyMcCallum
New Contributor III

I am also trying trying to sum values across all repeat records, excluding those with a specific category. It doesn't look a solution was found in this post. Any updates or suggestions on this?

0 Kudos
HaroldHerrera1
Occasional Contributor

Hello, did you resolve this issue? I have the same question...

0 Kudos