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

    Current week

    Del Booth

      Hi.

       

      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

      del