Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
sum({<Date={">=$(=Month(Max(Date)-1) <=$(=Month(Max(Date)) "}, Year=,Month=,MonthEndDate= >} [Amount (LCY)])