4 Replies Latest reply: Feb 18, 2012 1:22 AM by Deepak Kurup RSS

    Set help for YTD by month

    Gopinathan L

      Hi,

      I want to store sum of the selected months YTD value into variable and take the avg.

       

      for example,

       

      if i select feb,mar,

       

      ytd for feb is 100

      Ytd for mar is 120

       

      then i need to show the value(variable) is (100+120)/2(no.of selected months)=>220/2=110

       

      the problem i am facing is i dont know how to take the YTD for the selected months.

       

      I can take the YTD for the max month. using <=max(month) in set.

       

      if they select more than one month then i dont know how to do.

       

      could anyone help me.

       

      thanks in advance.