Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI all,
I m confused and not getting the logic..... for calculating "Month To date" for previous Month.
Please help by providing code for same . 🙂
Hi,
Please try the function.
=
addmonths(DateField,-1) . Ler me know is it useful or not?
Manesh Khot
I guess you want to calculate some amount for last MTD, if it is so, you can use something like this:
sum({Date={">=$(=MonthStart(today(),-1)) <=$(=Addmonths(today(),-1))"}>} Amount)
Regards, tresesco