Jump to content

Import/Capture an average summary result


This topic is 7292 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

Link to comment
Share on other sites

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?

Link to comment
Share on other sites

This topic is 7292 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.