Jump to content
Sign in to follow this  
Jredeemer14

Total Prices from multiple records in a Portal

Recommended Posts

I have a portal that has multiple records and each one has a unique ID. Sometimes it is necessary to have 2 of the same records in the portal, in the image for instance 2 delivery records are sometimes needed, yet in the total field (which is from the layout called invoices, the portal is from NonSerial Inventory) which has a calculation of Sum (tbl_NonSerial_Inventory::NonSerial Price)

Yet, it will not sum the price if there is more than 1 of the same item. I'm not sure why, unless it won't add it because it is the same record? Any help would be appreciated. Thanks - Jeff

portal.jpg

Share this post


Link to post
Share on other sites

I suspect your portal is not showing what you think it should show. Make sure it's pointed at the correct table occurrence, and that the fields in the portal are also from the same TO.

Share this post


Link to post
Share on other sites

I'm a little confused when you say "because it is the same record". The 2 portal rows are obviously 2 records. Is is possible that your calculation is pointing "thru" the portal, to a "inventory" table (which has only 1 record for this "product")?

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.