Return to FileMaker.com
How to get a summary of repeating fields?
How can I get a summary of only so many repetitions of a repeating field?
Field=dollar (25 repetitions)
want a total for repetitions 1-10
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.
Retrieving data ...