Calculations, calculations, calculations...

[aderium]

Scenary :

Master File

Related File

Fields:

Contract Number

DOP

QTY

TOTAL COST

The master file has a portal so that I can imput the above mentioned fields from the related file.

DOP has 4 options: A, B, C, D

I want to be able to visualize in field "Total A" of master file the sum (Field = Total Cost of related file) of all the DOP = A with the same contract number.

Please help!!!!

[LiveOak]

1) In the related file, create a calculated field:

DOP_A (calculation, number) =

If(DOP = "A", Total Cost, 0)

2) In your master file, create a field:

Total A (calculation, number) =

Sum(RelToRelatedFile::DOP_A)

The first step gives you a field in your related file which only shows values for DOP = "A". The second step sums up the DOP_A fields from related records.

-bd