I have a data which is from April 24 to Dec 24, in a calculation i want to show the current month data only,
I was using the following formula month(TODAY())-1 to get the current month and on this basis i was calculation the respective figures, but the same is not working, Till last month there were no Issues, but his month i am …
Any Issues???
CASE
WHEN MONTH(TODAY()) = 1 THEN 12
WHEN MONTH(TODAY()) = 2 THEN 1
WHEN MONTH(TODAY()) = 3 THEN 2
WHEN MONTH(TODAY()) = 4 THEN 3
WHEN MONTH(TODAY()) = 5 THEN 4
WHEN MONTH(TODAY()) = 6 THEN 5
WHEN MONTH(TODAY()) = 7 THEN 6
WHEN MONTH(TODAY()) = 8 THEN 7
WHEN MONTH(TODAY()) = 9 THEN 8
WHEN MONTH(TODAY()) = 10 THEN 9
WHEN MONTH(TODAY()) = 11 THEN 10
WHEN MONTH(TODAY()) = 12 THEN 11
END