3 Replies Latest reply on Jan 1, 2019 11:59 PM by Norbert Maijoor

# Pace that continues on days with no sales

Hello all,

I am working with Pace.  I recently posted and received a very good answer for the question I asked, but believe I was asking the wrong question.  Attached is my workbook that shows I want to keep track of the pace for the month.  My Pace calculation takes the running sum of Sales divides that by the # of the day and multiplies it my the # of days in the month.  This will work, however, I don't believe it will do what I want it to do, which is to continue to calculate a pace on days that don't yet have sales.  It's a little hard for me to figure out since I don't have 2019 data yet, but wanted to reach out and see if anyone had suggestions.

If today sales for the 3rd of January have been reported, then I want to divide that by the # of business Days (2) and multiply by the number of business days in January (22).  My calculation should take care of that.  However, instead of just plotting the Pace points at the days where sales are reported, I would like to see the pace for the entire month, quarter and/or even year, even those days without sales, meaning, I would like to carry the calculation of Running sum of Pace reported for each day of the month.

Anyone have any suggestions?

• ###### 1. Re: Pace that continues on days with no sales

Hi Jamie,

Not sure if it is applicable in your scenario but may be you could evaluate the capabilities of "scaffolding".

Scaffolding is explained here

Hope is helps,

Regards,

Norbert

• ###### 2. Re: Pace that continues on days with no sales

This is very interesting.  I watched the scaffolding with forecasts and it seems like this would work for me with some minor tweaking.  Thank you for the suggestion.  Now I just have to wait for 2019 Sales to load before I figure out if it is alright.

• ###### 3. Re: Pace that continues on days with no sales

Hi Jamie,

Glad it helps out. Could you close the thread with a "Helpful" or "Correct Answer" so the community is aware and can focus on other challenges.

Upfront a BIG thank you. Your cooperation is appreciated.

Regards,

Norbert

1 of 1 people found this helpful