I need the sum of a field located within a repeating (addInstance) subform to total in another subform, however they have different parent subforms. I have been able to calculate the total in separate subforms, however they have all had the same parent subform. I am trying to use:
if (exists(subform1[0].field1)==1) then
Sum(subform1[*].field1)
endif
- What am I doing incorrectly?