I do some calculations within a Repeating Group (red: quantity x price = subtotal (yellow 0).
Outside of the repeating group I would like to sum up (blue) the subtotals (yellow) towards one total sum ("To be calculated).
How is your database organised? I am assuming you have a data thing called Order which has a list of Parts attached to it. Are you saving in the database the quantity of parts which are being bought?
@nico.dicagno
ID / name / quantity / price #within one order always the same / apples / 2 / 1€ #within one order always the same / bananas / 5 / 2€
Already tried it multiple ways with search for but never made it …
Add a field called “subtotal”.
Make sure that when an Order is created the subtotal price is also calculated and added to the database
Now on your repeating group, rather than showing an element which is price*quantity, just show the order’s subtotal.
Add a workflow that is triggered when the “input quantity is changed” which recalculates the subtotal.
On the element outside the repeating group, you can put the dynamic text “repeating groups, list of orders, each item’s subtotal, sum”