Hi, I am trying to create a conditional statement where I output "Stage 2" for assets that fall between months 4 - 32. The problem is that I want it for assets with lease terms of 36 months. In my data set, I have assets with lease terms of both 36 and 48 months. Is this possible using a conditional statement? This is what I have but I am getting an error: IF [Term] == "36" && [Asset Period] >= "4" && [Asset Period] <= "32" THEN "Stage 2" ELSE "Stage 3" ENDIF
