AnsweredAssumed Answered

Repeating Field - Finding Values and Calculating

Question asked by alanfair on May 14, 2013
Latest reply on May 14, 2013 by davidanders


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