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

    Previous Month Sales



      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))'}




      [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.