8 Replies Latest reply on Nov 15, 2016 2:05 PM by Gert-Jan Neeft

    Sum Sales between two variable dates

    Jeff Roberts

      Hi, I dont know how to do this and cant find the right formula for a calculated field. 

       

      Here is the issue:

      • I have numerous accounts that each have individual contract start and end dates.  The start dates are dimensions called "2015 Contract Start Date" and the end dates are dimensions called "2015 Contract End Date"
      • I would like to look at these accounts on the Measure of "Sales$"

       

      Question: How can I sum "Sales$" for each account between the two date dimensions of "2015 Contract Start Date" and "2015 Contract End Date"?

       

      Here is a screen shot.