Skip to main content
Hi All,

 

I'm really confused with this error message if this the right error or Is it that I'm missing something here , your help here is much appriciated.

 

I have created a Process builder in which, in one of the node actions I have written a formula for Product ID. The logic is to create the Opportunity product by comparing 2 values ( 1 - Record Type and another custome picklist value from Account object) based on this condtion whether true or false the Product ID must be updated. For this is have created a formula to the best of my knowledge as below ( correct me here if this is not the right approach)  ( Used- Case function as it is part of Node Actions and ISPickval is not available)

 

IF((CASE([Opportunity].RecordType.Name,"New Development",1,0) && (CASE([Opportunity].Account.Sub_Asset_Type__c ,"Sale",1,0)) , $Label.WiredScore_Home_Sale_D_R_Discounted_Price_Certification_Fee_GB  , 

 

IF((CASE([Opportunity].RecordType.Name,"Occupied",1,0) && (CASE([Opportunity].Account.Sub_Asset_Type__c ,"Sale",1,0)) ,

 

$Label.WiredScore_Home_Sale_Occupied_Discounted_Price_Certification_Fee_GB , 

 

IF((CASE([Opportunity].RecordType.Name,"New Development",1,0) && (CASE([Opportunity].Account.Sub_Asset_Type__c ,"Rental",1,0)) , $Label.WiredScore_Home_Rental_D_R_Discounted_Price_Certification_Fee_GB  , 

 

IF((CASE([Opportunity].RecordType.Name,"Occupied",1,0) && (CASE([Opportunity].Account.Sub_Asset_Type__c ,"Rental",1,0)) ,

 

$Label.WiredScore_Home_Rental_Occupied_Discounted_Price_Certification_Fee_GB , "Null")

 

 
3 respuestas
  1. 16 dic 2020, 13:03
    Hi Padmashree,

     

    Give this a try:

    IF([Opportunity].RecordType.Name = "New Development" && [Opportunity].Account.Sub_Asset_Type__c = "Sale", $Label.WiredScore_Home_Sale_D_R_Discounted_Price_Certification_Fee_GB,

    IF([Opportunity].RecordType.Name = "Occupied" && [Opportunity].Account.Sub_Asset_Type__c = "Sale", $Label.WiredScore_Home_Sale_Occupied_Discounted_Price_Certification_Fee_GB,

    IF([Opportunity].RecordType.Name = "New Development" && [Opportunity].Account.Sub_Asset_Type__c = "Rental", $Label.WiredScore_Home_Rental_D_R_Discounted_Price_Certification_Fee_GB,

    IF([Opportunity].RecordType.Name = "Occupied" && [Opportunity].Account.Sub_Asset_Type__c = "Rental", $Label.WiredScore_Home_Rental_Occupied_Discounted_Price_Certification_Fee_GB, null))))

    Is your Sub_Asset_Type__c a picklist? If so, use this instead:

    IF([Opportunity].RecordType.Name = "New Development" && TEXT([Opportunity].Account.Sub_Asset_Type__c) = "Sale", $Label.WiredScore_Home_Sale_D_R_Discounted_Price_Certification_Fee_GB,

    IF([Opportunity].RecordType.Name = "Occupied" && TEXT([Opportunity].Account.Sub_Asset_Type__c) = "Sale", $Label.WiredScore_Home_Sale_Occupied_Discounted_Price_Certification_Fee_GB,

    IF([Opportunity].RecordType.Name = "New Development" && TEXT([Opportunity].Account.Sub_Asset_Type__c) = "Rental", $Label.WiredScore_Home_Rental_D_R_Discounted_Price_Certification_Fee_GB,

    IF([Opportunity].RecordType.Name = "Occupied" && TEXT([Opportunity].Account.Sub_Asset_Type__c) = "Rental", $Label.WiredScore_Home_Rental_Occupied_Discounted_Price_Certification_Fee_GB, null))))