Hi - New member here and novice Filemaker user.

I'm using version 5.5, and I don't know how to solve my calculation problem. I hope someone here can point me in the right direction.

My first file has basic data relating to inventory additions. There are multiple entries per inventory item. The Item ID is my match field. For each addition, I have a Quantity, and a code for the Type of addition (among other info).

My second file is meant to summarize the data. For each item ID, I want a total Quantity added, IF the code for the addition matches the Type of addition I want to summarize. (I am simplifying quite a bit.)

I'm not able to get the quantities to total the way I want. I think I'm missing a big step in the middle - I'm just trying to use an IF calculation in the summary file - IF(Type="x",sum(Quantity),0).

Thanks, thanks for any help.

If I understand you correctly, you'll need to create a calculation field, cQuantity, in the first file of Case( Type = "x", Quantity, 0 ). In the second file, using a relationship of ItemID to ItemID in the first file, create a calculation of Sum(relationship::cQuantity).

PERFECT. Thanks so much for your quick response. It worked.