1 Reply Latest reply on Mar 29, 2013 12:18 PM by Mark Holtz

    Previous Week Calculated Field

    Jesse LaBoda

      Hello ---

       

      I need to create a calculated field that would total up sales (column G) on the attached for the previously completed fiscal week.

       

      I thought the following would work..

       

      IF DATEPART('week',today()-1) = [acct_wk_i] THEN [Net_Sales] END

       

      But that doesn't work.

       

      Any ideas?

       

      Thanks!