Repeating Field - Finding Values and Calculating
I have a repeating field which allows for 10 repeats
There could be up to 10 numbers stored here but equally there could be any number from 1 to 10, and they could be in any position.
I know i can use the following to determine how many numbers I have in the repeatng field
count(fieldname) , lets assume this returns 5, meaning i have 5 numbers spread across my possible 10 entries.
Now what i need to do, and this is where i get stuck
For each number I need to multiply it by itself, and then add all the results together of the 5 repeats.
Hope that makes sense.
Any suggestions please