11 Replies Latest reply on Oct 22, 2018 8:16 AM by Hari Ankem

    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.