Hi all,
I have a requirement wherein I need to get the MTD for sum sales. initially used the below expression:
sum({<Date = {">=$MonthStart(Today()))<=$(=Date(Today()))"}>}Sales)---Gives data from Jan 01 - 19th Jan
The issue now we have different Accounting calendar where in we have following structure
Jan starts from Dec 15 (previous year)- jan15
Feb starts from Jan 16 - Feb 15 and so on...
for current date we need to get MTD which should follow the above calendar.
So MTD should bring in values from Jan 16th till current date. Any help would be greatly appreciated.
Kindly let me know if requirement is unclear.
Thanks,
Anupama Jagan
