|
|
Posted by Bethany Holliday on 10/18/74 11:34
Thanks for the tips. I'm a little confused about your advice to use 2
columns. Are you saying I should break it up - sum the payroll
sum(qtr_payroll) .. and then sum the employment sum(emp1_emp2+emp3) and
then derive my average wage from those 2 columns? My end result is that
I need an average wage. Average wage is the quarterly payroll, divided
by the sum of the monthly employment divided by 12 ..
Sorry if I missed something obvious .. I tried breaking it up and then
deriving the average wage in a 3 column from the 2 columns, that did not
work either:
sum(qtr_payroll) as qtr_payrroll, sum(emp1_emp2+emp3)/12 as qtr_emp,
sum(qtr_payroll / qtr_emp) as avwage
*** Sent via Developersdex http://www.developersdex.com ***
Navigation:
[Reply to this message]
|