Month as number for calculation

[StuartH]

Check out this thread, there is currently no system driven way to provide this, only way is to add a stream - but doing that gives more flexibility.

Plan by working days vs sales

Is there a way to build an automatically updating working day function? i.e. I’ve built a custom report that monitors sales vs plan but the plan is divided by number of working days in the month multiplied by number of days completed. Therefore shows sales vs a pro rata’d plan. Jan = 22 working days Friday 25th Jan was day 18 Jan plan total = 450,000 units Jan sales at 25th = 400,000 units Jan plan of 450,000 / 22 days * 18 days = 368,182 vs sales of 400,000. So we are 31,818 units above p…

My stream is hopefully going to be as follows: