1 Reply Latest reply on Aug 30, 2016 5:19 PM by Keshia Rose

    weekday

    Tina Matt

      ss

        • 1. Re: Week to Date Comparison
          Keshia Rose

          Hi Tina,

           

          Here is one possible way to go about this, albeit probably not the most elegant. First I split out the Week number using the split function.

          Then I created the following calculation:

          [Week In Qtr - Split 1] <= {MAX(if [Quarter] = {MAX([Quarter])} THEN [Week In Qtr - Split 1] END )}

           

          Basically this is first finding the maximum quarter, then for that quarter it is finding the most recent complete week. Then it checks each week to see if it is less than or equal to the most current week number.

           

          Once you've done this you can create a view like so:

           

          Let me know if this works out for you.

           

          Take care,

          Keshia

          3 of 3 people found this helpful