2 Replies Latest reply on Apr 11, 2016 2:27 AM by Hrvoje Gabelica

    Count number of records in two different date fields then sum amount

    Alexis Jasinski
      Date ADate B
      1/25/20161/18/2016
      1/24/20162/2/2016
      1/18/20163/1/2016
      1/16/20161/18/2016
      1/19/20161/16/2016
      1/20/20161/4/2016

       

      I am looking to count the number of rows by month/year in two different date fields. For example, in Date A there are 6 rows for January 2016 and in Date B there are 4 rows for January. Then I want to sum the both to make 10 rows for January 2016. The issue I am running into is that if I use Date A or Date B as my reference point, the numbers won't be accurate.

       

      I'm thinking something like this might work...

      If (Date A) then sum(number of records) end