3 Replies Latest reply on Sep 30, 2018 11:58 PM by Boroon Mahanta

    n-1 formula within a range of numbers

    Alec Chen

      Hi, I am interested in learning how to create a formula that computes the previous value within a set. Use case is a month-over-month or week-over-week comparison.

       

      1st use-case

      Months:

      [1,2,3,4,5,6,7,8,9,10,11,12]

      On Month 1, this should compare to previous year's Month 12.

       

      2nd use-case

      Fiscal Weeks

      [1,2,3,4,5,6,...52,53*]

      Sometimes in a fiscal calendar will include a 53rd week. How does one formulate a calculation to take week-over-week on Week 1 and identify whether it should be compared to previous year's Week 53 or 52?

       

       

      Thanks in advance.