AnsweredAssumed Answered

Look up Average

Question asked by kaotishe on Mar 20, 2017
Latest reply on Mar 20, 2017 by kaotishe

I am setting up a database to streamline product pricing. One of the things it will do is estimate labor cost as part of COGS. The thing is the labor can very dependent on which employee is doing it. As this is just a front end estimate that we use internally for pricing I would like for it to use the average pay for all of the employees. I know if I we getting the information for a single employee I could have it preform a look-up for that rate, but I would like it to determine the average rate for all employees. I am guessing a need to use a calculation to do this but I have not figured out how to write that.