I have a form that has a repeat group. In that group I have records that belong to one of three stores and information associated to each record that I would like to calculate. For example:
Store, Report Value
1, $100
2, $25
3, $10
1, $30
3, $100
In the end I was looking to use a calculate element to report the totals for each store where in the main form I would have
Store Report Value Total
1, $130
2, $25
3, $110
I can get use array_sum to get the total value of all of the records in the repeat group with no issue, but have nto found a way to filter the results by store so I can have the calculate column show the results as shown above.
Thanks in advance for you assistance.
-Eugene
Store, Report Value
1, $100
2, $25
3, $10
1, $30
3, $100
In the end I was looking to use a calculate element to report the totals for each store where in the main form I would have
Store Report Value Total
1, $130
2, $25
3, $110
I can get use array_sum to get the total value of all of the records in the repeat group with no issue, but have nto found a way to filter the results by store so I can have the calculate column show the results as shown above.
Thanks in advance for you assistance.
-Eugene