Skip to main content
Topics#Data ManagementJeremy King 的问题
Jeremy King (UnionSuite | Strategic Organizing Systems) 提问于 #Data Management
2018年11月9日 17:13

Incorrect number of parameters for function 'IF()'. Expected 3, received 4

Trying to get this to validate but I'm getting the "Incorrect number of parameters for function 'IF()'. Expected 3, received 4" error. A previous version validated and worked fine - I am now trying to add 

 

IF( Order.CVRSOS__Job__r.JOB_D_STRUC_CODE__c ="1", Order.CVRSOS__Job__r.JOB_BASE_SALARY__c * Order.CVRSOS__Job__r.JOB_D_STRUC_FACT__c, and am now haing issues getting the formula to validate.

 

 

IF( ISPICKVAL(PricebookEntry.Product2.Family, "Dues"), 
IF( PricebookEntry.Product2.ProductCode = "DUES_STANDARD",
IF( Order.CVRSOS__Job__r.CVRSOS__HourlyRate__c>=11.01, 
Order.CVRSOS__Job__r.CVRSOS__HourlyRate__c * 2.5,
Order.CVRSOS__Job__r.CVRSOS__HourlyRate__c * 2.0),
IF( PricebookEntry.Product2.ProductCode = "DUES_MULTIPLIER",
Order.CVRSOS__Job__r.CVRSOS__HourlyRate__c * 
PricebookEntry.Product2.CVRSOS__RateMultipler__c,
IF( Order.CVRSOS__Job__r.JOB_D_STRUC_CODE__c ="1",
Order.CVRSOS__Job__r.JOB_BASE_SALARY__c * 
Order.CVRSOS__Job__r.JOB_D_STRUC_FACT__c,  
UnitPrice 
)), 
0.0 
))

 

 
8 个回答
  1. Deepak K Anand (‎‎‎‎‎‎Zoom Communications, Inc.)
    2018年11月9日 17:29

    Ok following the bulleted points, you will need this = 

    IF(
        ISPICKVAL(PricebookEntry.Product2.Family, "Dues"), 
        IF(
            AND(
                PricebookEntry.Product2.ProductCode = "DUES_STANDARD",
                Order.CVRSOS__Job__r.CVRSOS__HourlyRate__c >= 11.01
            ),
            Order.CVRSOS__Job__r.CVRSOS__HourlyRate__c * 2.5,
            IF(
                PricebookEntry.Product2.ProductCode = "DUES_MULTIPLIER",
                Order.CVRSOS__Job__r.CVRSOS__HourlyRate__c * PricebookEntry.Product2.CVRSOS__RateMultipler__c,
                IF(
                    Order.CVRSOS__Job__r.JOB_D_STRUC_CODE__c = "1",
                    Order.CVRSOS__Job__r.JOB_BASE_SALARY__c * Order.CVRSOS__Job__r.JOB_D_STRUC_FACT__c,  
                    UnitPrice
                )
            )
        ),
        NULL
    )
撰写回答...
0/9000