I am asking for some insights into a issue I am having.
I have been asked to predict when the minimum stock level should be reached. Known numbers are: At the end on each day the level is measured for each Product. That gives us the Date and cur_level. We know what the average volume of each product's use is per day - daily_avg and we have a minimum level required value - low_level. In the attached spreadsheet I have 2 'theo??' fields. These are only there for my testing and they are not normally loaded into the app. My first crack to create the theo_date (date(Date+(floor(sum((cur_level-low_level)/daily_avg)))) ) went quite well, if we operated 7 days a week.
What I have been trying to achieve is to incorporate networkdays() into the expression, but only Saturdays, and I have not got this right. Alternatively I don't know if this would be any easier is to exclude any Sundays?
The attached spreadsheet has some simple working on what I am trying to achieve.
