1 Reply Latest reply on Jan 31, 2019 2:54 PM by Zhouyi Zhang

    How to calculate sum of previolsy months for Retantion Rate

    Willian Gasparino

      I have a table with all my sales record(account,date,sales_value)


      What i want to do is to calculate the retantion rate by this formula:




      (Sum of current quarter sales across all accounts, where each is capped at sum of prior quarter sales)



      (sum of prior quarter sales across all accounts)



      Thank you!