4 Replies Latest reply on Mar 8, 2016 4:12 PM by Shivang Desai

    Incrementing by 1 to a substring fetched

    Shivang Desai

      Hi all,

       

      I am trying to apply increment logic to the substring fetched.

       

      Screenshot (26).png

       

      So in the above diagram,

       

      The 3 graphs are for years 2013,14,15 and the dot is for 2016

      I am basically trying to shift that dot to week 2

       

      So I have a condition which says if the financial year = 2016 then increment my week 1 to week 2, so that dot is shifted.

      Week 01 , 02 ... 12   is a string and I need to add increment to the substring fetched (01 + 1 ) = Week 02

       

      My current logic is as follows:

       

      IF [Date_FiNancial_Year] = "2016/17" THEN "Week" + RIGHT([Date_Financial_Week],2) + 1  ELSE ([Date_Financial Week]) END

       

      I am getting an error because of +1 , how can I solve this?