fix one salesforce small formula field

Job ID: 37436293

Budget: $10 – $11 USD

Need to fix one formula field in salesforce

IF(ISPICKVAL(Product_Rate_Plan_Charge__r.zqu__Type__c, 'Recurring'),((IF(ISNULL(UnitPrice), Product_Rate_Plan_Charge__r.zqu__ListPrice__c , UnitPrice)) * Quantity),IF((Product_Rate_Plan_Charge__r.zqu__ProductRatePlanChargeName__c = 'SPV Tax Product: One-Time') , (UnitPrice- VALUE(Product_Rate_Plan_Charge__r.Cost__c))*Quantity, 0))

Updated formula:

IF(ISPICKVAL(Product_Rate_Plan_Charge__r.zqu__Type__c, 'Recurring'),((IF(ISNULL(UnitPrice), Product_Rate_Plan_Charge__r.zqu__ListPrice__c , UnitPrice)) * Quantity),IF((CONTAINS(Product_Rate_Plan_Charge__r.zqu__ProductRatePlanChargeName__c, 'First Year') , (UnitPrice- VALUE(Product_Rate_Plan_Charge__r.Cost__c))*Quantity, 0))

Related categories: Salesforce.com Salesforce App Development