0

In my report I'm trying to substitute "null" value from populating in my report to have "not matched" there are 2 existing picklist values that would appear otherwise.

I've tried

CASE(Lead.LD_Account_Coverage_Type__c, 
     "Territory","Territory", 
     "Named", "Named",
     else, "Not Matched")
  • Error when encoding row-level formula: Syntax error. Missing ')'

I've also tried

IF(ISPICKVAL(Lead.LD_Account_Coverage_Type__c,
   "Territory","Territory", "Named", "Named",else, "Not Matched") 

and I get the same error- anyone know what the correct formula is?

1
  • Please clarify your specific problem or provide additional details to highlight exactly what you need. As it's currently written, it's hard to tell exactly what you're asking.
    – Community Bot
    Mar 6, 2023 at 21:12

1 Answer 1

0

The structure of CASE is:

CASE(Lead.LD_Account_Coverage_Type__c, 
 "Territory","Territory", 
 "Named", "Named",
 "Not Matched") /* this is the otherwise path */

there is no else token

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .