5 Replies Latest reply on Oct 28, 2015 8:35 AM by Derrick Austin

    Summing Data by Date

    Brian Barmmer

      I have two tables:  One that has daily information and another that has monthly periods dates.

      I'm looking to create a calculated field that sums daily data based on the start / end dates in the monthly periods

       

      Capture.PNG

       

      I can create a calculated field that works if I use parameters, but it needs to be more automatic.

      Is something like this on the right path?

      Capture1.PNG

      Thank you