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?