Total Prices from multiple records in a Portal

[Jredeemer14]

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

[comment]

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.

[Fenton]

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")?

[comment]

Yeah, that's more likely.