1 Reply Latest reply on Sep 23, 2015 1:16 PM by diego.medrano

    How to calculate net new using open and closed dates?

    Kyle Davis

      I am trying to calculate the number of net new accounts over a given time period using an account open date and an account closed date.  When I try to do a calculation it's not able to see/count any of the Open Dates that have not Closed, since those cannot be shown using the filters and the years shown in the columns. For example, the chart cannot see/count an account that opened in 2014, but did not close since we are only looking at 2014 close date records. Thanks for any help you can give.