Calculated Field Not working, Similar ones work fine

Question & Answer
1

Hello All, I’ve made a couple calculated fields that work in a system to find the lowest value of two assessment types.

Screen Shot 2022-06-24 at 12.38.14 PM
Screen Shot 2022-06-24 at 12.38.14 PM1920×1200 66.6 KB

The final category is supposed to be “masters”, “exemplary” and so on instead of 1-4. The Syntax I’ve tried using to convert the numbers into the larger categories is as follows:

ifelse(
{Final Category}=4, “Masters”,
{Final Category}=3, “Exemplary”,
{Final Category}=2, “Recognized”,
“Ineligible”)

I’m getting an error on the first {final category} and I’m not sure why. Any help on this topic would be great. Thanks.

2

Hi @ethan_shaffer -

It’s possible you are trying to compare an integer with a string. I can’t tell the data type of ‘Final Category’ from the image.

You can quickly check this by switching your integers to strings in your calculated field and see if it works.

ifelse(
{Final Category}='4', “Masters”,
{Final Category}='3', “Exemplary”,
{Final Category}='2', “Recognized”,
“Ineligible”)