Totaling fields in a repeating subform

Follow

Scott Bennett

• April 03, 2018 17:13

I am trying to total a field in a repeating subform on to an element on the main form. Has anyone doe this??

0

• 

  Lucas Drege

  • April 04, 2018 16:34
  • Edited

  hi Scott,

  In order to total a field in a repeating subform to an element on the main form, please use the formula field and choose the sum listed in the drop-down, and select the Field/Tokens in the subform to be added.

  As an example, ${Invoice_Subform/Amount:[this]} is a field in a repeatable subform whose sum needs to be calculated on the main form,  Use the formula field in the main form, and use the Function: sum which provides: sum(${numberArray:[*]}).  Replace the numberarray:[*] with the field that is to be calculated. i.e. Sum(${Invoice_Subform/Amount:[*]}). 

  

  0

  Comment actions Permalink

Please sign in to leave a comment.