Forum Discussion
Average Count
Hi folks. People Have been amazing so far helping me understand what to do. Hoping we can get this next bit running ok. I work out Current EMployees using this piece of code which works great: ...
Thanks,
I amended to use the code you provided, but get the same answer.
in the example I am using, I have the date filtered to 31/10/22, and the staff count there is 1789 (Employed Staff Count). The staff count today is 1996 (Current Staff). So adding those together then dividing by two should be 1892.5. But the result seems to be 1788.