Problems with Sum function in double repetition structures

Question

I have a repetition structure for father(parcelas) and son (terrasolta). When performing the sum of a variable(terra_solta) of the child repetition, I receive only the value of the last position, and not the sum of all repetitions of the variable (terra_solta).

How can I solve this? I need to receive the sum of terra_solta for all repetitions!

Exemplo.xlsx

a1.png

dougbrowning · Accepted Answer

Double repeat needs a double sum.

So sum outside of repeat 2 (but inside repeat 1) into a field, then sum that field outside repeat 1.

Works for me.  Hope that helps