Skip to content
English
  • There are no suggestions because the search field is empty.

Calculating a Total Outside of a Repeatable Group

How to calculate a total outside of a repeatable group

If you have a repeatable group that contains a dynamic table with calculated fields and you want to add the calculated values together outside of the repeatable group, follow these steps:

  1. Add a repeatable group to your form. In this example, the repeatable group is named Order.
  2. Add a dynamic table to the repeatable group. In this example, the dynamic table contains three columns:
    • Quantity — Number type
    • Unit Price — Number type
    • Line Total — Calculated Field Type
  3. Click the dynamic table, then expand Input Options. Toggle on Use Summary Row.
  4. Click the Line Total column and expand Input Options.
  5. Click (Edit Equation) and enter the calculated field equation. In this example:
  6. Add a calculated field outside of the repeatable group and name it Grand Total.
  7. Expand Input Options.
  8. Click (Edit Equation) to open the Equation window and enter the equation that references the Line Total summary. In this example:
  9. Click the repeatable group and expand Summary Settings. Using this example, select Order_Dynamic_Table_Line_Total_Summary as the Fields to Summarize.
  10. Select SUM as the Summary Type.
  11. The Reference Name field will display Order_Dynamic_Table_Line_Total_Summary_SUM.
  12. Save your changes.
  13. Preview the form to verify that the calculations are accurate and that the Grand Total correctly reflects the sum of all Line Total values.