Month wise recievables.

[#1]

Hello,

           i am using this formula to calculate recievables.

I get correct value if i select june it gives the data till june end date. If select may it give sum till end of May.

I want to make another expresstion which shows data till Month -1? So if i select june it should show data june as well as may.

How to improve following expresstion?

sum({<Date={"<=$(=Max(Date))"}, Year=,Month=,MonthEndDate= >} [Amount (LCY)])

thanks

Lavi

[rajni_batra]

sum({<Date={">=$(=Month(Max(Date)-1)  <=$(=Month(Max(Date)) "}, Year=,Month=,MonthEndDate= >} [Amount (LCY)])