Jump to content
Sign in to follow this  
Rick Ransijn

Portal Row with Calculation field

Recommended Posts

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?

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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?

Share this post


Link to post
Share on other sites

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!

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

By using this site, you agree to our Terms of Use.