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.
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.
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.
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?