MTD Calculations

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: MTD Calculations

sunny_talwar — Fri, 19 Jan 2018 12:27:21 GMT

Why isn't Feb starting from Jan 15th? I guess how would I know when is Mar begin? 15th Feb or 16th Feb? Similarly other months....