3 Replies Latest reply: Dec 15, 2011 11:39 AM by matthew thompson RSS

    Previous Month Sales

      Hi,

       

      I'm trying to query sales from 8 months ago. Using the following query, I'm able to sum the current month's sales using the following:

       

      [Calendar Month Name] = {'$(=month(now(0)))'}

       

      However I cannot use the above query to sum sales for a previous month. For instance if I try:

       

      [Calendar Month Name] = {'$(=month(now(0)-8))'}

       

      OR

       

      [Calendar Month Name] = {'$(=month(now(0))-8)'}

       

      Both return nothing. Does anyone have an idea what I'm missing? I've searched the forum and have yet to find a solution.

       

      Any help is appreciated.

       

      Matt