2 Replies Latest reply on Mar 9, 2012 9:40 AM by Mark Manning

    convert string to number?

    Mark Manning

      Hello Experts,

       

      I have an IF THEN variable where I want to know if variable 1 is larger today than it was last year:

       

      if sum([variable1]) > LOOKUP(ZN(SUM([variable1])), -1) then '1' else '0' end

       

      Question:  I want to be able to run some calculations on the result of this IF THEN statement.  So, ideally, I want to have this variable create numeric 1s and 0s, rather than string 1s and 0s.  Is this possible?

       

      Thanks to all.