Skip to main content
Topics#FormulasPregunta de ManojKumar Muthu
ManojKumar Muthu (Appviewx) preguntó en #Formulas
25 ene 2019, 11:40

If else condition in formula field

Hi there,

I have 3 pick list field in "Opportunity Object" base on the I selection a value shoud get arrived in another field name"ARR_value__c"

1. Opportunity_Type__c: New License, License Renewal, PS-Managed Services, AMC, PS

2. License_Type__c: Annual, Perpetual, One Time

3. Payment_Terms__c: Upfront, Annual, Monthly, Milestone

 and the condition is

If(Opportunity_Type__c='New License' && License_Type__c='Annual' && Payment_Terms__c='Upfront' )

{

ARR_value__c = (Bookings__c/License_period__c)*12

}

else if(Opportunity_Type__c='New License' && License_Type__c='Perpetual' && Payment_Terms__c='Upfront' )

{

ARR_value__c = Bookings__c* 20%

}

else if(Opportunity_Type__c='New License' && License_Type__c='One Time' && Payment_Terms__c='Monthly' )

{

ARR_value__c = (Bookings__c/License_period__c)*12

}

note: Bookings__c and License_period__c are number field

TIA

 

 
1 respuesta
  1. Lokesh Kumar (Google)
    25 ene 2019, 12:49
    IF(TEXT(Opportunity_Type__c) == 'New License',
    	IF(TEXT(License_Type__c) == 'Annual' && TEXT(Payment_Terms__c)== 'Upfront', ARR_value__c = (Bookings__c/License_period__c)*12,
    		IF(TEXT(License_Type__c) == 'Perpetual' && TEXT(Payment_Terms__c)== 'Upfront', ARR_value__c  = Bookings__c* 20,
    			IF(TEXT(License_Type__c) == 'One Time') && TEXT(Payment_Terms__c)== 'Monthly', ARR_value__c = (Bookings__c/License_period__c)*12,0))),0)

    Try this
Escribir una respuesta...
0/9000