Adding up values from a portal

[Jredeemer14]

Hello, I'm have multiple inventory items (records) in a portal and they have prices, but I would like to add something outside the portal in the same layout to total up the multiple inventory prices. How would I got about this? I have attached a picture to show what I'm doing.

[Fenton]

A calculation field, in the table referencing the portal:

Sum ( portal's relationship::Price )

It will be an unstored field, not indexed.

(P.S. In later versions of FileMaker you can create a Summary field, Total of Price, in the line items table. Then target that field alone from the parent table, using portal's relationship. But for old timers such as myself, I still use Sum() on the number field.)

[Jredeemer14]

Works like a Charm, figures it would be something as simple as that. Thanks a bunch!