This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Just to complement what Qiu mentioned, which I believe to be correct.
When applying a numeric function to a string value, the formula tool will flag like everything is okay until the last error, so this is why you have colors above and only flagging the last instance of the error as an error.
Just change the column data type to be a numeric and you will be all set.
I attached couple of pictures to explain, for illustration.