2 Replies Latest reply on Oct 19, 2018 3:19 PM by Andrew Alcazar

    Compare Counts From Two Different Date Fields in Same Table

    Andrew Alcazar

      Hello,

       

      Wondering how to compare counts from two different date fields that are in the same table?

       

      For example, my table has a "Rental Start Date" and a "Rental End Date", though "Rental End Date" is null if it hasn't been returned. What I want to is compare the In and Out Rate per month, so how many items went out to the customer and how many have been returned. I can easily find the counts in different worksheets, but I would like to calculate the rate for each month in the same table. Is there a way to do this? Appreciate the help.

       

      Thank you.