2 Replies Latest reply: Mar 21, 2016 3:27 AM by vijaykrishnamraju vegesna RSS

    How to calculate "Last week" value ?

    Jim Chan

      Hello there,

       

      I want to know how to calculate "last week" value. as i have checked on the community , it is as such,

       

      sum({$<Date={">=$(=weekstart(max(Date),-1))<=$(=weekend(max(Date),-1))"}>} [my revenue])

       

      is it correct? for last week value. ?

       

      Rgds

       

      Jim