Budget Phasing

[NormanStanleyBadger]

Hello, I hope everybody is well.

Aim: To create a budget table which is apportioned on a sale day basis.

So far I have created the table below.

Customer No	Start Date	End Date	Budget
1	01/01/2024	31/01/2024	50
1	01/02/2024	29/02/2024	50

The plan is to use an intervalmatch to apportion the budget, however, before that I need to calculate the apportionment basis figure, for example,

March = 50 / NetworkDays(Start Date, End Date)

The issue is customers only sell their product on certain days and ideally I would like to only apportion the budget based on their sale days. 

Does anybody have any idea how this can be achieved?

[dmac1971]

Are you basing the number of sales days for each customer on a previous month, year etc?  If so then simply look the same period last year, count the number of sales days and divide budget by that.  Then count the same number this year from month start to today?

[NormanStanleyBadger]

Hi, thanks for your response. 

I have a list from the sales department of the sale days per customer. I have partly resolved this using networkdays and interval match.

NSB