20 Replies Latest reply: Mar 6, 2013 4:28 AM by Eleanor Donoghue RSS

    Rolling 12 Months HELP!

      Why is my expression giving me everthing and not just the past 12 months?

      Getting really bored of trying to figure it out and all other posts are either going way over my head or i can't work out what i need to adjust to make them fit my report.

       

      Any help will be much appreciated!

       

      Elly

       

       

      sum

      ({1<[HEADERS.Posting MonthEnd]={">=$(=addmonths(monthenddate(max([HEADERS.Posting MonthEnd]))+1,-12))

      <=$(=max([HEADERS.Posting MonthEnd]))"
      }>}

      {1<
      ITEM_UOM_GP.Brand={'2 DRAINAGE'}>}

      {1<
      [ITEM_UOM_GP.Reporting UOM Sub Sub Group]={'Accessories'}>}

      (
      Quantity )/1000)