Pacing Formula - Useful for tracking budgets and other monthly goals

nick.lanspa · September 15, 2020, 9:53pm

Just wanted to share a useful formula I reuse fairly often to ensure I’m on pace to hit monthly budget and volume goals. It will show you the percentage you’re off from where you should be today.

For this example, I use a parameters to set the values for [This Month] and [Budget].

[Current Total] / (([Budget] / DateDiff(“day”, Date([This Month]), Date(EndOfMonth([This Month])))) * DateDiff(“day”, Date([This Month]), Date(Today())))

erica · September 15, 2020, 10:00pm

Is the parameter [This Month] used to input the number of the current month (e.g. 9 for September)? If so, you could use Today() and DatePart to automatically grab that value.
That said, it’s probably useful to be able to manually toggle what month you’re looking at. I imagine that the first first days of the month, you’re probably looking at last month’s results.

system · October 15, 2020, 11:42pm

system · October 30, 2020, 1:06pm

system · November 17, 2020, 5:37am

Hugo · December 1, 2020, 9:33am

Hi Nick,

We should be careful using DateDiff to calculate the days of a month. For example, you will get only 30 days for December using your formula.

system · December 20, 2020, 3:21pm

system · January 9, 2021, 7:09pm

system · January 30, 2021, 3:33am

system · February 20, 2021, 1:23pm

system · March 13, 2021, 11:26pm

system · April 4, 2021, 1:26pm

system · April 26, 2021, 3:14am

system · May 17, 2021, 11:15pm

system · June 9, 2021, 4:55am

system · July 2, 2021, 1:54am

system · July 24, 2021, 6:18pm

system · August 16, 2021, 9:30am

system · September 8, 2021, 9:33pm

system · October 2, 2021, 7:53am