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

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.