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?