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



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


      2nd use-case

      Fiscal Weeks


      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.