Average2

fanninam — Wed, 25 Nov 2020 16:16:04 GMT

What would I need to do to the following statement to make it take the average of EjFTE?

NUM(Sum({$<HCOE={'Human Costs'}>}Actaul_Amount)/Sum(EjFTE),'$#,##0.')

EjFTE is "Full Time Employees". I want the sum of Human cost divided by the average number of Full Time Employees.

Re: Average2

Anonymous — Thu, 06 Apr 2017 20:16:47 GMT

NUM(Sum({$<HCOE={'Human Costs'}>}Actaul_Amount)/count(EjFTE),'$#,##0.')