6 Replies Latest reply: Jun 14, 2018 2:52 AM by Ruben Marin RSS

    Set Analysis divide monthly value into daily value

    Peggy Wells

      I am having trouble creating a chart that will track percent to plan by day.  The plan is loaded in a script with fiscal day equal to the last fiscal day of the month.  I am creating combo chart with the Fiscal_Days as dimension.  Using the below as an example, I am trying to create a Plan by day estimate, but i can not get the calculation with Plan in it to show except on day 20 where it is loaded.  

       

      My last failed attempt is : (sum({$<{Fiscal_Days=,Period={'Jan'}>}Plan))/max(Fiscal_Days)

      This only appears on Day 20.


      For this example, I would like to see the daily plan of $1000 in the graph referencing the above formula. 

      Any thoughts??

       

      PeriodYearFiscal_DaysSalesPlan
      Jan201811000
      Jan201821010
      Jan201831020
      Jan201841030
      Jan201851040
      Jan201861050
      Jan201871060
      Jan201881070
      Jan201891080
      Jan2018101090
      Jan2018111100
      Jan2018121110
      Jan2018131120
      Jan2018141130
      Jan2018151140
      Jan2018161150
      Jan2018171160
      Jan2018181170
      Jan2018191180
      Jan201820119020000