Divide Sales data with (current month+2)

[Anonymous]

Hi,

I have a requirements where my sales data should be divided by current Month +2

For example :

Current month is 6 ( Jun), 

(Current Month+2) = 6+2=8

and I want to divide the sales by 8 (AUG), 

for next current month(jul) ( , the sales data should be divided by 9 (SEP) and so on.

Having challenge when the current month is 11(NOv), adding 2 will give me 13, but it should be 1 which is Jan.

Also 12(dec) should give me 2(feb)

Any help with the measure?

Thanks,

Tejaswi

[az38 · Accepted solution]

Hi @Anonymous 

smth like

Denominator = 
var _m = MONTH(TODAY())
RETURN
IF(_m > 10, _m - 10, _m + 2)

[Anonymous]

HI @az38 

Thanks for your reply!

Thsi is what I was looking for.

Thnaks,

Tejaswi