4 Replies Latest reply on Nov 26, 2013 10:36 AM by Jeff Stanley

    Month's since Start and annualized amount

    Jeff Stanley

      I would like to calculate the number of months since a "firm" has been a customer, essentially the number of months from today back to the first transaction. This number would then be used to filter out those who have been customers for less than 6 months, and calculate a projected 12 month total based on the average monthly sales for the remainder. I have attached a sample