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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

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