Month wise recievables.

Tue, 14 Aug 2012 07:56:04 GMT

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

Re: Month wise recievables.

rajni_batra — Tue, 14 Aug 2012 09:08:01 GMT

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