Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
fanninam
Creator
Creator

Average2

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.

1 Reply
Anonymous
Not applicable

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