8 Replies Latest reply: Aug 24, 2017 9:39 AM by Anindya Manna RSS

    How to calculate previous month ignoring other selection

    Anindya Manna

      I am calculating previous month date(AddMonths(date#(max([Months Number]),'YYYYMM'),-1),'YYYYMM') by using this formula for calculating previous month sales.

      But when I am choosing any Rep id then the previous month calculation is going changed as per the rep id selection.

      How to keep it fixed? Means I want the previous month is always max(month number)-1 irrespective of any selection.