You need to sign in to do that
Don't have an account?
GMASJ
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
Please suggest me how to fix this issue.
Thanks
Sudhir
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
https://help.salesforce.com/apex/HTViewSolution?urlname=Formula-field-exceeds-maximum-number-of-characters-1327109401516&language=en_US
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.