Calculations with repeating fields?

[ghostwriter11]

I have two number fields, FEES and ADDITIONAL FEES.

 

I made ADDITIONAL FEES a repeating field with 3 repetitions.

 

The calculation field TOTAL FEES adds these two number fields.

 

However, it only calculates using the first repetition of ADDITIONAL FEES.

 

Is there a way to make it add up all the repetitions when making its calculation?

 

Thanks in advance.

[comment]

Try:

 

FEES + Sum ( ADDITIONAL FEES )

 

Think twice before using repeating fields for data that needs to found and/or summarized. Portals are much better suited for this.

[ghostwriter11]

Wow, that's just what I was looking for! Thanks. This forum is great.

 

I'll investigate portals, too. Thanks.

 

Try:

 

FEES + Sum ( ADDITIONAL FEES )

 

Think twice before using repeating fields for data that needs to found and/or summarized. Portals are much better suited for this.