3 Replies Latest reply on Mar 30, 2017 10:10 AM by Yuriy Fal

    This week vs. Last Week on a Sunday!

    Ben Powis

      Hello everyone,

       

      I have a report which updates every day, showing daily statistics for yesterday, compared to last week. To do this I index the weeks and show weeks 0 (this week) and 1 (last week) with the following formula:

      DATEDIFF('week', [Date], today(), 'monday')

       

      This work's fine until the report runs on a Monday morning, when the report looks like this - note my 'previous week' column data for Sunday is the same as this week, because now the week index has rolled. Does anyone have any suggestions on a way around this? I thought about a floating grid over Sunday only, showing weeks 2 and 3, but this is not ideal as I show the Prev week totals all week, and they would only be correct on a Monday. I also use this formula to power some charts on the report.

       

      Any help would be much appreciated!

      Grid.png