Cannot find why my formula will not verify

[CaspioChris]

I have an issue with the following formula. This version verifies, but when I use the actual field of Max_Potential _Score for the >=86 and <91, I get an error. Any idea in what is causing this? 

CASE
WHEN [@field:Max_Potential_Score] >=97 THEN '5-STAR POTENTIAL'
ELSE
WHEN [@field:Max_Potential_Score] >=91 AND [@field:Max_Potential_Score] <97 THEN '4-STAR POTENTIAL'
ELSE
WHEN  [@cbParamVirtual9]>=86 AND [@cbParamVirtual9] <91 THEN '3-STAR POTENTIAL'
ELSE
WHEN [@field:Max_Potential_Score] >=73 AND [@field:Max_Potential_Score] <86 THEN '2-STAR POTENTIAL'
ELSE
WHEN [@field:Max_Potential_Score]  >=60 AND [@field:Max_Potential_Score] <73 THEN '1-STAR POTENTIAL'
ELSE
'STOP'

END

[PotatoMato]

Hi @CaspioChris, 

You have multiple ELSEs on your case statement. You will only use ELSE if you want to end the condition. For example:

CASE

WHEN [@field:Age] >= 65 THEN ‘Senior’

WHEN [@field:Age] >= 18 AND [@field:Age] < 65 THEN ‘Adult’

ELSE ‘Minor’

END

For troubleshooting, try inserting the condition 1 by 1 to check which line will cause the error.

Is the field "Max_Potential _Score" a number/integer data type?

 

-Potato

[Queso]

Hi @CaspioChris,

You may also refer to the following Caspio HowTo article's example 4: https://howto.caspio.com/datapages/reports/advanced-reporting/calculations-in-forms-and-reports/#:~:text=based on conditions.-,Example 4%3A,-The example below