CASE: If we need to sanctioned a loan amount then we have security picklist field with salary and assert options.
If we selected salary as security then different % for sanctioning loan amount on different Loan type like housing, personal If assert is selected as a security then rate on interest will be 60% of assert cost...
Here is the formula i created, Please find the error for me in the below formula.
------------------------------
If( ISPACKVAL(Security__c,'Salary'), Case ( Loan_Type__c, 'Education',20*0.12*Salary__c, 'Vahicle',10*0.11*Salary__c, 'Housing',15*0.13*Salary__c, 'Personal',30*0.14*Salary__c, 0 ), Assert_Cost__c *0.60, )
--------------------
Newbie to coding. don't
#Trailhead even know about ABC of coding. pls be kind if there is a silly mistake I have made.
Hi,
Please try-
IF(
ISPICKVAL(Security__c,'Salary'),
Case(Loan_Type__c,
'Education',20*0.12*Salary__c,
'Vahicle',10*0.11*Salary__c,
'Housing',15*0.13*Salary__c,
'Personal',30*0.14*Salary__c,
0 ),
Assert_Cost__c *0.60
)
