Month as number for calculation

[Jeriel]

I am trying to create a report which use current month as period. I was wondering if there is a way to pick month convert it number for calculation. Does anyone tried it before?

Samples below

Current month CM = July
CM = 7

Calculation
Month Cover = 10 months volume / CM + 3

[ShaneAngel]

Welcome to PUG @Jeriel.

I am unsure on answering your question directly, but maybe you can do a different calculation using the {period_count} functionality in custom mode found on this page?

[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:

[Jeriel]

Thanks

Regards,
Jeriel Gangoso

[janthony]

Hi,

Aside from the {PERIOD_DAYS}, there is a hidden gem where you can use case statements in Custom formulas. Below is an example where I need to get sales for the last weekday using a SQL function to drive the logic:

^CASE WHEN DATENAME(weekday,GETDATE()) = ‘Monday’ THEN {a} ELSE {b} END

{a} = sales for yesterday - 2
{b} = sales for yesterday

You could do something similar if there are no better methods.

Cheers,
John

[Jeriel]

thanks

Regards,
Jeriel Gangoso