AnsweredAssumed Answered

Calculate month to date

Question asked by aelvin@board.com 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

Outcomes