# Month as number for calculation

**URL:** <https://pug.phocassoftware.com/t/month-as-number-for-calculation/1098>\
**Category:** Ask the Community\
**Created:** [July 1, 2019, 1:39am UTC](https://pug.phocassoftware.com/t/month-as-number-for-calculation/1098 "2019-07-01T01:39:14Z")\
**Posts on this page:** 1\
**Showing post:** 3

<div class="post-metadata">

**Author:** ![StuartH](https://sea1.discourse-cdn.com/flex015/user_avatar/pug.phocassoftware.com/stuarth/32/394_2.png) [@StuartH](https://pug.phocassoftware.com/u/StuartH)\
**Post date:** [July 1, 2019, 11:31am UTC](https://pug.phocassoftware.com/t/month-as-number-for-calculation/1098/3 "2019-07-01T11:31:17Z")

</div>

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](https://pug.phocassoftware.com/t/plan-by-working-days-vs-sales/872):
>
> 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:

 ![image](https://us1.discourse-cdn.com/flex015/uploads/phocassoftware/original/1X/a1f30bdc827e8bdf07f6c73c3d549fc0921245e4.png)

---

_[View the full topic](https://pug.phocassoftware.com/t/month-as-number-for-calculation/1098)._