• Addnon
  • NEWBIE
  • 0 Points
  • Member since 2013

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

Hi,

 

I am trying to create a Case formula, but only getting "OTHER" for all records.

 

CASE(  $UserRole.Name  ,
                "BRK Rep", "CORE",            
                "BRX Rep", "CORE",              
                "Bulk", "BULK",
                "Commercial Strategic Accounts", "STRATEGIC",
                "Construction Specialist Rep","CORE",         
                "CT Rep", "CORE",
                "Enterprise Rep", "CORE",
                "LIE Rep","CORE",
                "LIW Rep", "CORE",
                "Manager for Sales Agent", "AGENT",
                "NJC Rep", "CORE",              
                "NJN Rep", "CORE",
                "NJS Rep", "CORE",
                "Power to Learn", "POWER TO LEARN",
                "Power to Learn Sales", "POWER TO LEARN",
                "Power to Learn Sales Agents", "POWER TO LEARN",
                "WC Rep", "CORE",
             "OTHER")

  • September 16, 2013
  • Like
  • 0

Hi,

 

I am trying to create a Case formula, but only getting "OTHER" for all records.

 

CASE(  $UserRole.Name  ,
                "BRK Rep", "CORE",            
                "BRX Rep", "CORE",              
                "Bulk", "BULK",
                "Commercial Strategic Accounts", "STRATEGIC",
                "Construction Specialist Rep","CORE",         
                "CT Rep", "CORE",
                "Enterprise Rep", "CORE",
                "LIE Rep","CORE",
                "LIW Rep", "CORE",
                "Manager for Sales Agent", "AGENT",
                "NJC Rep", "CORE",              
                "NJN Rep", "CORE",
                "NJS Rep", "CORE",
                "Power to Learn", "POWER TO LEARN",
                "Power to Learn Sales", "POWER TO LEARN",
                "Power to Learn Sales Agents", "POWER TO LEARN",
                "WC Rep", "CORE",
             "OTHER")

  • September 16, 2013
  • Like
  • 0