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'

You can post now and register later.
If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

## Question

## 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

## Link to comment

## Share on other sites

## 2 answers to this question

## Recommended Posts

## Join the conversation

Note:Your post will require moderator approval before it will be visible.