4 Replies Latest reply on Nov 30, 2018 2:13 PM by Chris Chalmers

    Creating a calculation using more than one date field

    Elvira Giampapa

      How do I calculate the following:

       

      Account # 12345     Plantinum, customer as of : 2/18/18   Monthly sales:     jan 2018 $7000,  Feb2018 $8500,  Mar 2018 $10500, Apr 2018 $6500 May 2018: $8800 Jun 2018 $11000 Jul 2018 $9500, Aug 2018 $7500, Sep2018 $7200, Oct2018 $6200

       

      I have a calculation that gives me the average $ in sales for Jan - Oct 2018

       

      However, how do I create a formula that gives me the average sales for this account based on when the date when they became a platinum customer?  So I want the calculation to give me the average of Feb-Oct

       

      Thanks!