Skip to main content
Dheeraj Verma (Concentrix) 님이 #Sales Cloud에 질문했습니다

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개
  1. 2021년 10월 7일 오전 6:08

    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

    )

    )