10 Replies Latest reply: Sep 5, 2016 11:52 AM by Bharat Kishore RSS

    Need year start and year end

    Bharat Kishore

      Hi All,

       

      I have a month field and in that  i have data like jan-15 to may-16.

       

      Now my requirement is i need to calculate data like jan -16 to may 16.

       

      As of now i have hard coded and written the expression as

       

      sum(if(S5_Month2>='1/1/2016', if(S5_Month2<='5/1/2016',([S5_Leads])))).

       

      But i don't want like this in hard coded. I need to write based on variables.

       

      I have given two variables like YearStart(S5_Month2) and MonthEnd(S5_Month2)..

       

      Can you please help me how can i achieve that expression.

       

      Thanks,

      Bharat