Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
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.')