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


      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