calculate a total based on X relation and Y value

[ezorb]

i have file that contains transaction records: record number,record date, Material type, transaction type, transaction quantity.

in another file I want to total the transaction quantity for all transactions that occurred on a particular date, have the material code "X" and are transaction type "Ship"

the result is that i want the current days shipments for a particular material to total and auto enter based on this calculation when i create a new record, but i want it to ignore other transaction types such as "xfer"

help please

Oliver

[Ugo DI LUCA]

Hello,

Make a concanated calc field =

concanate = record date&"-"& Material type&"-"& transaction type

and use this concanated calc at left side and right side of a selfjoin relationship.

Then Sum(selfjoin::Quantity) will give you the total amount for any Material type shipped at record date.