2 Replies Latest reply: Jan 31, 2015 6:00 AM by Elena Prandoni RSS

    Calculating Values from a "Preset Week" to the "Max Week"

    Aut.Mark Aut.Mark

      Hi all,

      i need some help....

      I would like to calculate ,e.g. by selecting the "WEEK" field  from 1 to last one :

      1) The result of MARGIN% from Week 1 to Max(WEEK)

      2) The result of MARGIN% from Week 1 to Max(WEEK)-1)

      3) The Difference between these 2 values.

       

       

      In other words:

      If i select the first  5 weeks of the year 2015 , i would like to obtain something like that:

      -----------------------------------------------------------------------------------------------------------

      if

      MARGIN% (between Week 1 and week 5) 

      <

      MARGIN% (between Week 1 and week 4), 'ALERT','OK')

      -----------------------------------------------------------------------------------------------------------

      i can't figure out....

       

      Thanks

       

      Mark