nshively Member

• Activity
• Discussions11
• Comments20

• Re: How to Create Monthly Averages for Headcount?

  nshively

  November 2021
  Nevermind, I realized it was a simple solution since I have the EOMDate: SUM(`TermCount`)/ ((SUM(`ActiveCount`))/COUNT(DISTINCT `EOM_DateKey`)) It just divides the total count of active employees per…
  1