Calculate Average

Nov.

3

2008

How To Divide HeadCount by the Period Number

by Jan Harrigan CPA

Anybody need FRx to calculate an average?

Today’s post is compliments of Rick Tenorio. Rick is the moderator at the newsgroup at microsoft.public.frx, and he has collected a number of helpful and practical documents on using FRx. This initial post covers how to divide a headcount statistic by the period number in order to arrive at an average headcount.

Note that you can also use this technique to calculate average sales per period (use YTD revenue divided by the period number). I know a number of my clients do this in order to get an initial sense of whether their MTD revenue looks right. [click to continue…]

{ 10 comments }