I've got ann Orders file that relates to a Line_items file by Order_ID.
A Line-item is Order_ID, Part_ID, Part_Type, Quantity, Price and
Total_cost. There are a half dozen Part Types.

In my Orders file, I have a portal that lists all of the fields from
Line_items. I want to have calc fields on my Orders file that give me
subtotals for each Type of Line Item. I tried creating a calc field
for each Type in Orders that ran like...

If( Line_items::Part_Type="Misc", Sum(Line_items::Total_cost, 0)

But that seems to sum all the line items under the first portal row
type and *not* each individual type.

Anyone?
G

I did a little more searching and found this solution which works just
fine.

http://groups-beta.google.com/group/...a11f6c83bff951