Apex Code Development You need to sign in to do that
Don't have an account?
Picklist fields are only supported in certain functions.
Hi,
I am trying to build a formula field (number) to track to number of opportunities of a certain type that contain a certain product. I have a field called "Type of Sale" (picklist) that we use to track the type of sales we make (Serialization, Serialization and aggregation, Inspection, etc). I want to create a field that will look at that field and if it has a certain value (Serialization OR Serialization and aggregation) AND a certain product (BottleTracker OR CartonTracker OR Flying CartonTracker OR Manual Print Station OR PackStation CAP OR PacStation SAP OR PackStation SAP OR LabelTracker OR BunderTracker) is attached to the opportunity, the field value will be 1. If not, it will be 0. I will then use that field to report of the % of Serialization AND Serialization and aggregation sales that include the aforementioned products.
I have came up with the following formula:
IF(AND(OR(Type_of_Sale__c="Serialization", Type_of_Sale__C="Serialization and aggreation"), (OR(PricebookEntry.Product2.Name="BottleTracker", PricebookEntry.Product2.Name="CartonTracker", PricebookEntry.Product2.Name="Manual Print Station", PricebookEntry.Product2.Name="PackStation CAP", PricebookEntry.Product2.Name="PackStation FMP", PricebookEntry.Product2.Name="PackStation SAP", PricebookEntry.Product2.Name="BundleTracker", PricebookEntry.Product2.Name="LabelTracker")), 1, 0))
When I use the "check syntax" button, the syntax is fine, but it tells me that "Picklist fields are only supported in certain functions".
How should I proceed to achieve my goal? I have absolutely no experience with advanced formulas so please dumb it down to my level.
I am trying to build a formula field (number) to track to number of opportunities of a certain type that contain a certain product. I have a field called "Type of Sale" (picklist) that we use to track the type of sales we make (Serialization, Serialization and aggregation, Inspection, etc). I want to create a field that will look at that field and if it has a certain value (Serialization OR Serialization and aggregation) AND a certain product (BottleTracker OR CartonTracker OR Flying CartonTracker OR Manual Print Station OR PackStation CAP OR PacStation SAP OR PackStation SAP OR LabelTracker OR BunderTracker) is attached to the opportunity, the field value will be 1. If not, it will be 0. I will then use that field to report of the % of Serialization AND Serialization and aggregation sales that include the aforementioned products.
I have came up with the following formula:
IF(AND(OR(Type_of_Sale__c="Serialization", Type_of_Sale__C="Serialization and aggreation"), (OR(PricebookEntry.Product2.Name="BottleTracker", PricebookEntry.Product2.Name="CartonTracker", PricebookEntry.Product2.Name="Manual Print Station", PricebookEntry.Product2.Name="PackStation CAP", PricebookEntry.Product2.Name="PackStation FMP", PricebookEntry.Product2.Name="PackStation SAP", PricebookEntry.Product2.Name="BundleTracker", PricebookEntry.Product2.Name="LabelTracker")), 1, 0))
When I use the "check syntax" button, the syntax is fine, but it tells me that "Picklist fields are only supported in certain functions".
How should I proceed to achieve my goal? I have absolutely no experience with advanced formulas so please dumb it down to my level.
All Answers
I however had to move my new field to the Opportunity Product object in order for it to work. It doesn't affect my capacity to report on it so that is perfect.
Once again, thank you very much for your MUCH appreciated help.
Have a nice day,
Matt
public static void ispick(list<opportunity> picval){
for(opportunity test:picval){
if(test.revenue_type__c <>'renewel&expansion'){
if(test.revenue_type__c <>'renewel'){
//test.adderror(test.competitor__c=null);
test.competitor__c.addError('competitor field is mandatory');
test.lost_reason__c .addError('lost reson field is mandatory');
}
}
}
}
}
write the trigger for it