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.