Sum of repeating field repetitions?

[jasonwood]

How do you calculate the sum of all repetitions of a repeating field? Yes I know repeating fields are a bad way to go... I'm just trying to make a simple modification to an existing database which happens to use repeating fields.

Thanks!

[trevorg]

Just use the Sum command.

Sum(RepeatingField)

This will add all the repetitions.

(Make sure they are all numeric)