Portal Row with Calculation field

[Rick Ransijn]

I have a calculation field and using a repetition of 10.

Now the calculation is only performed on the first repetition.

Any idea why this is happening?

[jbante]

This sort of things happens often in repeating calculation fields that reference non-repeating fields. Repetition 3 of a repeating calculation will try to reference repetition 3 of the other field, which doesn't exist. You should wrap references to non-repeating fields with the Extend () function so FileMaker knows to use the value from the first (only) repetition.

What does this have to do with portals? Portals and repeating fields are not the same thing.

[Rick Ransijn]

My fault in the topic title.. its not a portal row sorry. Just a repetition field.. Title should be.. Repetition field with calculation..

This sort of things happens often in repeating calculation fields that reference non-repeating fields. Repetition 3 of a repeating calculation will try to reference repetition 3 of the other field, which doesn't exist. You should wrap references to non-repeating fields with the Extend () function so FileMaker knows to use the value from the first (only) repetition.

What does this have to do with portals? Portals and repeating fields are not the same thing.

How do I use this Extend?

[Rick Ransijn]

Ok, hmm.. I got it.. i had changed the field in my calculation that I added to a higher repetition and added extend to that field into the calculation and it works... Thanks!