9 Replies Latest reply: Jun 13, 2018 8:29 AM by Silambarasan Manickam RSS

    Current week

    Del Booth



      I created a master calendar using Josh Goods creating a master Calendar post.  I have tried using the week (I have called it Colweek) field to specify a week to sum data as below: ie sum the quantity collected for week 24. 


      sum({< ColYear=(2018),ColWeek=(24)>} [Quantity Collected])


      Unfortunatly it does not work, Also how would I specify it to sum for the current or previous week instead of specifying week n umbers.


      Many thanks