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!