Addmonths issue in chart

[Kushal_Chawda]

Hi,

I am facing issue with addmonths fucntion.

I have chart having dimension Product & product group. I want to show opening balance as closing of prev month.

I am using expression as sum({<MonthYear = {'$(=addmonths(MonthYear,-1))'}>} Amount) but its not working..

Please help me out to write the expression for getting previous month amount

[CELAMBARASAN]

How your are creating MonthYear  field?

Month(Date)& Year(Date) or using MonthName function?

Celambarasan

[Kushal_Chawda]

Hi,

I am using monthname function..

For testing purpose when I am writing expression: addmonths(Monthyear,-1) in text object.  I am selecting year 2013 month Apr then getting Mar 2013.. So MonthYear field is proper.

[Kushal_Chawda · Accepted solution]

Hi,

Got the answer..

sum({<MonthYear= {'=AddMonths(MonthYear,-1)'}>}Amount).. not required $