Hey guys can anyone check my formula and help me figure out what is wrong with it? What I want is to change the value in variable SECTIONNAME if it meets the following condition, else leave it as it was. Instead it takes many values for the variable SECTIONNAME and changes them to 0 :/
IF [POLICY_YEAR]<=2016 and [GREATPLAINSCODE]="755"
THEN [SECTIONNAME]="WKA"
ELSE [SECTIONNAME]
ENDIF
Solved! Go to Solution.