You need to sign in to do that
Don't have an account?
ManojKumar Muthu
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
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
Try this