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.
You can get this by creating a single FY-FW field and using a LOOKUP() function to seek the SUM over the previous week. Attached is your example.
Hope this helps.