Skip to main content

Hi Team,

 

Below is the formula in process builder which is giving me the incorrect result in "QC" field.

 

If(ISPICKVAL([Opportunity].Type ,'Renewal'),[Opportunity].ARR__c , [Opportunity].Annual_Revenue__c ), If(ISPICKVAL([Opportunity].Type ,'Renewal') && ISPICKVAL([Opportunity].Billing_Frequency__c , 'Annual') && [Opportunity].ARR__c <=5000,[Opportunity].ARR__c  * 1.25,[Opportunity].Annual_Revenue__c)

 

Can anyone please help me to fix this?

 

Scenario: If opty type is "Renewal" only then ARR__c value should be assigned to "QC" field. i.e if it has other than "Renewal" type

 

#Sales Cloud then Annual Revenue should go in QC.

 

Else if  opty type is "Renewal" && Billing Frequency is "Annual && ARR <= 5K then ARR*1.25 else Annual Revenue should go in QC

4 answers
  1. Oct 7, 2021, 6:08 AM

    Hi Dheeraj,

     

    You can switch the if statements. Actually, when the first If condition is matched, the second one is ignored. So you want the second if statement as priority, then just put it in the first place.

     

    IF(

    AND(ISPICKVAL([Opportunity].Type ,'Renewal'), ISPICKVAL([Opportunity].Billing_Frequency__c , 'Annual'), [Opportunity].ARR__c <=5000),

    [Opportunity].ARR__c * 1.25,

    IF(ISPICKVAL([Opportunity].Type, 'Renewal'),[Opportunity].ARR__c ,

    [Opportunity].Annual_Revenue__c

    )

    )