• Jean Walters
  • NEWBIE
  • 0 Points
  • Member since 2014

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 0
    Questions
  • 1
    Replies

Hi.

 

I've got two fields that should calculate a score based on a number of other field values. Using case statements like this:

MAX(0,MIN(100,(
(

CASE( How_Big_Is_Your_Data_Environment__c,
"Less than 100 GB",0,
"100-500 GB",1,
"500 GB- 1 TB",2,
"1 TB- 50 TB",5,
"50 TB-100 TB",5,
"100 TB- 1 PB",4,
"1 PB +",3,
0.5) 
+
CASE( What_Of_Your_Data_Is_Unstructured__c,
"Less than 10%",0,
"10%-25%",2,
"25%-50%",6,
"50%-75%",10,
"75%-100%",10,
0.5)
 

 I'm able to get a lead score, but only when it comes to picklist values. But I'd like to do the same thing with a checkbox value. For instance, I have a field called "Requested Download" which is a checkbox. I tried something like this:

 

CASE( Requested_Download__C,

"True", 50,

"False", 1,

)

 

And I get an error telling me this is the incorrect use of a case statement. So, how would I be able to do this using a checkbox value?

 

Thank You.