AnsweredAssumed Answered

Calculate month to date

Question asked by Employee on Dec 2, 2017
Latest reply on Dec 12, 2017 by antoniospeca

Hello, Can anyone help out with how to calculate a month to date and campare with the month to date previous year?  The scenario I want to create is col 1 is Current week which will be displayed either choosing a week from the selector or using a pager, col 3 will be same week previous year.  Column 3 will be month to date based on the week selected, i.e. if 2nd week in the month is selected then MTD will be two weeks of data, col 4 will be MTD Last year so again first two weeks from the same month last year so that a like for like comparison can be drawn.

Thank you