Now don't jump all over me for using repeating fields.

I have done this in other FM tables but I've got a new one where it just isn't working.

I have an itemization list and cost in separate repeating fields, 10 reps.  I've done this before where I create a calculation field get the the Sum of the cost field.  Sum(ItemizationCost).

But in this new table it's not getting anything past the first iteration of the field.  I've tried various other scenarios all to no avail.  Everything is in the same table.

Any suggestions?

Any suggestions?

Don't use repeating fields.

a calculation field get the the Sum of the cost field.  Sum(ItemizationCost).

If ItemizationCost is a Number field (or a Calculation field with the result type set to Number), then Sum ( ItemizationCost ) should return the sum of all repetitions of ItemizationCost. This is assuming both fields are defined in the same table, and that you expect to see the sum of all repetitions in a single record.

Edited June 26, 201510 yr by comment

That's exactly what I thought, but it's not happening.  The calculation is only returning the value in the first repeating field.  If I delete that first value and leave the rest, the calc returns nothing.

Don't use repeating fields.

Really!?!?  Like I needed that.  You're a big help.

 

"where I create a calculation field "

Isn't that a repeating  number field with option to auto-enter a calculation, instead?

Your description of the fields can't be accurate.

 

SumReps.fmp12.zip

Edited June 26, 201510 yr by BruceR

BruceR and Raybaudi,

You both could be right.  Perhaps I was zoned out when starting this; who knows.

I ended up deleting the 3 fields in question and starting over again.  Now it's all working as expected.   Go figure.

Thanks for your direction, it helped more than you know.