Totaling fields in a repeating subform

追蹤

Scott Bennett

• 2018年04月03日 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

  • 2018年04月04日 16:34
  • 編輯於

  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

  評論操作 永久連結

請登入寫評論。