+ Start a Discussion
GMASJGMASJ 

Maximum size is 5,000 characters

Hi Experts, 

 I am using below simple formula to save and not able to save due to some limation not sure what is the issue in below formula I tried both using CASE and NESTED IF both giving the same error message 
 
IF
 
IF((infer3__Infer_Rating__c & TEXT(inferb1__brating__c) =  'A1'), '1-A1',
IF((infer3__Infer_Rating__c & TEXT(inferb1__brating__c) =  'A2'), '2-A2',
IF((infer3__Infer_Rating__c & TEXT(inferb1__brating__c) =  'B1'), '3-B1',
IF((infer3__Infer_Rating__c & TEXT(inferb1__brating__c) =  'B2'), '4-B2',
IF((infer3__Infer_Rating__c & TEXT(inferb1__brating__c) =  'A3'), '5-A3',
IF((infer3__Infer_Rating__c & TEXT(inferb1__brating__c) =  'A4'), '6-A4',
IF((infer3__Infer_Rating__c & TEXT(inferb1__brating__c) =  'B3'), '7-B3',
IF((infer3__Infer_Rating__c & TEXT(inferb1__brating__c) =  'B4'), '8-B4',
IF((infer3__Infer_Rating__c & TEXT(inferb1__brating__c) =  'C1'), '9-C1',
IF((infer3__Infer_Rating__c & TEXT(inferb1__brating__c) =  'C2'), '10-C2',
'100'
))))))))))
 
CASE
 
CASE(
infer3__Infer_Rating__c & TEXT(inferb1__brating__c), 
'A1', '1-A1',
'A2', '2-A2',
'B1', '3-B1',
'B2', '4-B2',
'A3', '5-A3',
'A4', '6-A4',
'B3', '7-B3',
'B4', '8-B4',
'C1', '9-C1',
'C2', '10-C2'
,'100')

Please suggest me how to fix this issue. 

Thanks
Sudhir
MellowRenMellowRen
My guess is that infer3__Infer_Rating__c and inferb1__brating__c are formula fields. And big ones.

When you write a formula that uses another formula field, Salesforce does not use the result of the other field rather it, behind the scenes, copies and embeds the formula of the other field into this field. As a result this adds to the character count even though in the UI you can’t see it.