13 Replies Latest reply on Apr 10, 2018 12:02 PM by Emrick Altidor

    How to calculate new data entry based on giving date

    Emrick Altidor

      Hello,

      I am looking to create a calculate field where I will be able to count the number of new entries for a giving month. Column A has the data I need to count. XYZ first bill in 1/1/2018 and XCV in 2/1/2018. I need to find the 1st time they bill and the total amount MRC + OCC.

       

       

      ADate BillCharge TypeAmount
      XYZ1/1/2018MRC300
      XYZ1/1/2018OCC500
      XYZ2/1/2018MRC300
      XYZ3/1/2018MRC300
      XCV2/1/2018MRC300
      XCV2/1/2018OCC500
      XCV3/1/2018MRC300
      ZAQ2/1/2018MRC300
      ZAQ2/1/2018OCC500
      ZAQ3/1/2018MRC300