2 Replies Latest reply on Jul 30, 2018 10:05 AM by Stephen Pelkofer

    Summing Data based on a start and end date in each row

    Stephen Pelkofer

      Is there a way for me to create a calculated field that would be the range of a start date and end date. Each row in my dataset has a "call date" and a "30 days prior" date. My goal is to sum the amount of quotes within that time period. The quote data is coming from a different data set, which I have already joined.

       

      For example, where the 'Abc's are, I want the sum of quotes in between those two dates.

       

      Thank you!