2 Replies Latest reply: Jul 28, 2015 12:18 PM by Allison Brown RSS

    Week over Week Change

      Hi,

       

      I am trying to create a week over week change formula based on max week start date

       

      I have this as the current week: sum ({<[Week Start Date]= {'$(=Max([Week Start Date]))'}>} [2015 Actual])

       

      and I tried this as the previous week: sum ({<[Week Start Date]= {'$(=Max([Week Start Date])-7)'}>} [2015 Actual]) which is returning nothing.

       

      I'm guessing I have the minus 7 in the wrong spot?

       

      I would then divide the two and subtract 1 to get WoW change