2 Replies Latest reply: Mar 5, 2013 7:14 AM by Manideep Hv RSS

    Set Analysis – summing value depending on selected periods

    Phil Colbert

      I have a summing up issue!!!

       

      I have a selector box of values 1 – 12 (periods)

       

      Loaded into qilkview I also have days per period i.e. period 1=31 days, period 2=28 days ,period 3=31 days etc…

       

      What I’m trying to achieve is to sum the daysPerPeriod depending on the periods selected (or even better to remove user input and to sum the total days for the total periods currently available for the max year)

       

      I’ve tried hardcoding the year and periods available into a variable to pull back the total days but get crazy numbers.

       

      What I really want to do is to sum(daysPerPeriod) where Year = max(Year) and Period = total periods available for year selected

       

      any help greatly appreciated

       

      daysPerPeriod
      Year
      Period
      312012

      1

      3820122
      3120123
      3020124
      3120125
      3020126
      3020127
      3120128