1 Reply Latest reply on May 14, 2013 4:21 PM by davidanders

    Repeating Field - Finding Values and Calculating

    alanfair

      Title

      Repeating Field - Finding Values and Calculating

      Post

           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