Jump to content

CaspioChris

Members
  • Posts

    1
  • Joined

  • Last visited

CaspioChris's Achievements

  1. 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
×
×
  • Create New...