Calculating Total of One Field in a Portal.

[cathyka]

I am so new I don't even know if I know how to ask this question correctly, but hopefully you guys can help.

I have a table for Print Specs.

I have a table for Fulfillment Specs.

I am creating a variety of packages (Fulfillment) using a combination of pieces (Print)

Each package is a totally unique combination and quantity of pieces.

I created a table table to hold the quantity of each piece as it relates to the package.

I have a layout showing Fulfillment Spec Records.

With a portal showing the related Quantity Piece Records.

I need to take the "quantity" field of every portal row in the record to create a "total" field in the Fulfillment table. I know this should be a simple calculation, but I can't figure it out.

Thanks in advance for you help.

[Transmasco]

Create a calc field in fulfillment:

=Sum(WhereverQuantityIsTable:Quantity)

[cathyka]

Thank you!

I wasn't using the calc field.

I was using a number field with a calculated value.

[Myke]

I am using the sum function to try and add up total qty of a specific item ordered on all Purchase Orders. this is the caluclation I am using .... Sum ( purchase orders::Qty )

the "purchase order" table is related to the "items" by item name. It then returns the PO#, date and qty in the portal list -this is all working fine, but when it gives me a summary, it's totaling up ALL qty's on each returned PO, for the other items (not in the portal) as well as the one I am working with.

[-Queue-]

Please do not hijack an existing thread. Create a new thread for your question instead.