1 Reply Latest reply on Feb 25, 2010 9:37 AM by mrvodka

    How to get a summary of repeating fields?

    kilbot

      Title

      How to get a summary of repeating fields?

      Post

      How can I get a summary of only so many repetitions of a repeating field?

       

       

      Example:

      Field=dollar (25 repetitions)

      want a total for repetitions 1-10

       

        • 1. Re: How to get a summary of repeating fields?
          mrvodka
            

          I dont think that you should be using repeating fields like this. Instead use a related table.

           

           

          Evaluate ( Substitute ( LeftValues ( List ( dollar ) ;10 ); ¶; "+" ) & "+0" )

           

           

          One would think that a simple: Sum ( LeftValues ( List ( dollar ) ;10 ) ) would work but FM wont allow the Sum () function to be used that way.