Recode a numeric field into a text field
Im struggling with this. Have a numeric field Scores.I want to make a new custom column where Scores >50 are "Good" and Scores <51 are "Poor".
Trying variations of if("Score">'50',"Good","Poor") ....... but keep getting errors.
Any assistance appreciated.
Regards