4 Replies Latest reply: Jun 3, 2013 4:46 AM by Gysbert Wassenaar RSS

    -7 network days calculation syntax

    Bradley Coyne

      Hi i am trying to set an expression to calculate the last seven working days.

       

      I have one key figure - weeklyusage

       

      the syntax i have is as follows, however is incorrect

       

      =sum(networkdays(today()-7), weeklyusage)))

       

      Your help is greatly appreciated.

       

      Best,

      Bradley