Thanks Kaushik. That works. I am trying to create another field apart from closed month to display only certain months as below:
if(ClosedMonth=month(addmonths(Today(1),-4)) and Year(Closeddate) = Year(Today(1)),ClosedMonth)
I am getting an error "Missing Right Paranthesis". But all brackets seem to be right. The same expression works in the expression editor.
Any thoughts on this?