Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
How to calculate Avg head count for Quarter.
Thanks,
Krishna
Please post the sample data with expected output
Hi,
Can your provide some info.
with some sample . what you desired to get?
-Hirish
Actual Head count:
Q1 7256
Q2 7553
Q3 7599
Q4 7699
Average head count:
Q1 6807
EX: Q1=Apr,May,Jun
6681 +6759+6981=20421/3= 6807
Hi,
Can you please specify ,
EX: Q1=Apr,May,Jun
6681 +6759+6981=20421/3= 6807
where are these above numbers ? And its not Q1 will be Q2
please provide your data format
-Hirish
Hi Harish,
I need for all quarters.
please find attached sample data.
What is a difference between actual head count and average head count? How is Actual head count getting calculated?
No attachment!!!
He attached it here: Calculate AVG Head count