1 Reply Latest reply on Aug 15, 2017 1:57 PM by Deepak Rai

    returning last numbers

    Alex Martino

      I wrote this formula but contract ID is an integer so it's not working. Is there anyway around that?

       

      if mid([Contract ID],10,0)=0 THEN RIGHT([Contract ID],1) ELSE RIGHT([Contract ID],2) END