function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Vani KumariVani Kumari 

Picklist value Error in the formula

Hello Everyone

I am new to the salesforce, I am working on a formula field where i am trying calculate the values from 2 seperate parent child objects
 I am tring to design a formula but i am getting an error
 
 "Error: Incorrect number of parameters for function 'ISPICKVAL()'. Expected 2, received 4"
 
 Any suggestion would be really helpfull
 
 below is my formula
 
 IF(TEXT(ISPICKVAL( Project_Resource__r.Billing_Type__c , "Per Hour", Project_Resource__r.Rate_Card__c  * ( Days_Calculation__c + Currency_Cost__c ) * 8,
IF(TEXT(ISPICKVAL(Project_Resource__r.Billing_Type__c , "Per Day",Project_Resource__r.Rate_Card__c  * ( Days_Calculation__c + Currency_Cost__c ),
IF(TEXT(ISPICKVAL(Project_Resource__r.Billing_Type__c , "Calendar Man-month Working Days",Project_Resource__r.Rate_Card__c  * ( Days_Calculation__c + Currency_Cost__c ),
IF(TEXT(ISPICKVAL(Project_Resource__r.Billing_Type__c , "Calendar Man-Month Days",Project_Resource__r.Rate_Card__c  * ( Days_Calculation__c + Currency_Cost__c ),
IF(TEXT(ISPICKVAL(Project_Resource__r.Billing_Type__c , "Custom",Project_Resource__r.Rate_Card__c  * ( Days_Calculation__c + Currency_Cost__c ),Null)))))))))))))))
Best Answer chosen by Vani Kumari
ABravo473ABravo473
ISPICKVAL takes only two parameters.
i.e : ISPICKVAL(fieldname, expectedValue)
In the above case, you are trying to fit in the conditional statement inside the PICKVAL itself. it should be :
IF(ISPICKVAL( Project_Resource__r.Billing_Type__c , "Per Hour"), Project_Resource__r.Rate_Card__c  * ( Days_Calculation__c + Currency_Cost__c ) * 8, IF(ISPICKVAL(Project_Resource__r.Billing_Type__c , "Per Day"), Project_Resource__r.Rate_Card__c  * ( Days_Calculation__c + Currency_Cost__c ), and so on.