7 Replies Latest reply on Oct 24, 2019 8:52 PM by Zhouyi Zhang

    Calculation for a Year-over-Year formula

    Nicholas Gunadi

      I am trying to think of a formula to calculate sales number year over year.

       

      ideally, if i am reporting the sales number for jan 15 2019, i want it to comp against whatever the number was 365 days ago, in this case it's jan 15 2018.

       

      Here's an idea of how my formula will look like (it's incorrect format/syntax, of course.)

       

      [ if(date = today then sales) - if(date = 365 days then sales) ] / if(date = 365 days then sales)

       

      thanks in advance!