Excluding current month data in set analysis

[lucasdavis500]

I have a variable I use to only show data from the previous month, as well as a two month lag

vPreviousMonth =  "$(=Month(AddMonths(Date(Today()),-1)))"

vTwoMonthLag =  "$(=Month(AddMonths(Date(Today()),-2)))"

stored in my variable overview. I changed these formulas to try to also do the most current month:

vCurrentMonth = "$(=Month(AddMonths(Date(Today()),-2)))"

OR

vCurrentMonth = "$(=Month(Date(Today()))))"

In set analysis I'm trying to do exclude the most current month from charts using this formula:

Month -= {$(vCurrentMonth)}

but it's not working, however when I try to just view a two month lag, or previous month data with the top formulas it seems to work, does anyone have any insight into this?

[sunny_talwar · Accepted solution]

Do you have one extra parenthesis in the end it seems here. Try this:

vCurrentMonth = "$(=Month(Date(Today())))"

[lucasdavis500]

Haha... must have missed that... thanks for catching it, I was trying all different sorts of ways to go about this and couldn't seem to get it right.