9 Replies Latest reply on Jun 15, 2018 10:32 AM by Helen Wang

    How to calculate QoQ in Table Calculation

    Helen Wang

      Hi All,

       

      My question is:

      I want to calculate QoQ with a formula like this: QoQ 2018 Q1 = 2018Q1/2017Q1 - 1

      Basically, it is used this year quarter compared against previous year quarter.

       

      Currently my selection in Table Calculation is not working.

       

       

       

       

       

       

       

       

       

      I cannot share the dataset but I would really love some ideas or advice.