0 Replies Latest reply on Sep 16, 2013 11:29 AM by Darin Friedrichs

    Extending Calculated Field Line through Year End

    Darin Friedrichs

      Hi,

      I've got data for weekly sales and a yearly sales estimate. I've created a field that is a rolling calculation of the weekly sales needed to meet the goal by year end.

       

      So each week it takes the goal minus the year's total and divides it by the number of week's remaining.

       

      avg(DATEDIFF('week',[ReportDate],#June 1, 2014#)) / [YearTotal]-Running_Sum(Sum([Sales]))

       

      Is there anyway to have this extended throughout the year? Right now the calculated field plots each week that has sales, but I'm trying to figure out a way to have the most recent calculated value extended to the rest of the year.

       

      For example the dots are the calculated field that I'm trying to have extend through week 52

       

      Thanks

       

      Capture.PNG.png