Hi, I'm trying to figure out why I get the error "Expected 'END' to match 'IF' at character 88 for the following calculated field I"m creating to show status:
IF AVG([calc-Priority Numeric]) = 1 AND AVG([calc-Hours Resolved]) > 4 THEN "Red"
ELSE IF AVG([calc-Priority Numeric]) = 1 AND AVG([calc-Hours Resolved]) <= 4 THEN "Green"
ELSE IF AVG([calc-Priority Numeric]) = 2 AND AVG([calc-Hours Resolved]) > 8 THEN "Red"
ELSE IF AVG([calc-Priority Numeric]) = 2 AND AVG([calc-Hours Resolved]) <= 8 THEN "Green"
ELSE "Blue" END
END
Change your "ELSE IF" to "ELSEIF" (ie 1 word only) and remove the END on the second last line.
IF AVG([calc-Priority Numeric]) = 1 AND AVG([calc-Hours Resolved]) > 4 THEN "Red"
ELSEIF AVG([calc-Priority Numeric]) = 1 AND AVG([calc-Hours Resolved]) <= 4 THEN "Green"
ELSEIF AVG([calc-Priority Numeric]) = 2 AND AVG([calc-Hours Resolved]) > 8 THEN "Red"
ELSEIF AVG([calc-Priority Numeric]) = 2 AND AVG([calc-Hours Resolved]) <= 8 THEN "Green"
ELSE "Blue"
END
