My form contains a repeating table that is populated from a secondary data source. The table contains two columns a "category" column and an "amount" column.
There are three possible values that could be in the category column of each row, and I have three "total" fields in another part of the form.
The idea is that one total will have the sums of all amounts that have a category of "a" , the second the sum of all amounts with category "b" the third with all amounts of catergory "c".
I tried implementing this with a Rule on the amount field that would add it's own value to "totalfielda" if its category = a. This doesn't seem to work. Since the user doesn't input the values in the reapeating table, the Rule never gets invoked.
Is there a way to do this without coding? And if not, how can I access each amount and category field in the reapeating table to perform the calculation for another field?