I am having problems with this formula, getting the below error
IF(CASE(RecordType.Id,
'01240000ALU', LPAD( TEXT(x_ID__c), 7, '0'), NULL), NULL) +
CASE(RecordTypeId, '0124000GLU', Y_ID__c ,
'01240000000NVN', Z_ID__c, NULL)
Error: Incorrect number of parameters for function 'IF()'. Expected 3, received 2
Please help me with these.
Prathyusha
4 Antworten
Hello Prathyusha,
Can you let us know what are you trying to calculate in your formula? Probably there is a simplified approach to that.
"01240000ALU" - This does not look like a ID value in Salesforce, it is either 15 or 18 characters long.
