0 Replies Latest reply: Sep 19, 2017 10:17 AM by Carlos Fernandez RSS

    Get Net Sales

    Carlos Fernandez

      I have gross sales ytd, but I need to get net sales. There can be sales that happened in prior years that cancelled this year.  How can I get net. I have a Sales Date Column and a Cancel Date column.

      In other words I need a way to get the following, whether an equation or creating variables/tables:

       

      Net Sales= Count(Sales Date)- Count(Cancel Date)

      YTD Net Sales As of 5/2/2017 (Only select Year 2017 Sales Date)

      A- 1

      B-1

       

      DivisionSales StageSale DateCancel Date

      A

      Sold1/1/2017
      BSold1/1/2017
      BSold1/1/2017
      APending Sale5/1/2017
      ACancel6/1/20153/1/2017
      ACancel2/1/20172/5/2017
      BCanceled1/1/2017
      ASold1/1/2017