I have a file with a report with a summary field "Average price hour by year" (Salaries file)

There is any chance to capture this result to use it in another file (Actuations) in order to calculate the cost of an actuation = "number of hours of actuation" (of one agent) * "Average Price hour by year"(Of the same agent).

This has by done by scripting. But I don't know if I can capture this result (Average) from a subsummary part of one report to use it in another relationshipped file? Is possible?

thanks a lot

FileMaker Version: 6

Platform: Mac OS X Panther

I did it!

Using a calculation field =(Round(Average(GT_Linies_despesa::Cost_hora_mes_agent); 2). This is a Self-join that give me the Average_Price_hour of each staff member.

But now I have another problem: that average should be by year and this calculation give me all years of one person!!

Please, any ideas?