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. ?