FavoriteVineeth Vasu (Kong Inc.) asked in #Data ManagementMar 23, 2020, 8:22 PMVR for opportunity productif opp type = incremental only or renewal with incremental & revenue type = new, the change type field must be populated. how to write VR fo this?3 answersSortSort by DateSort by Most HelpfulSort by DateLoadingAccepted AnswerMadan Lal Bakoliya (Salesforce)Mar 23, 2020, 8:34 PMTry this:AND( OR( ISPICKVAL( type, "incremental only" ), ISPICKVAL( type, "renewal with incremental" ) ), ISPICKVAL(revenue_type__c,"New"), ISBLANK(TEXT(change_type__c))) I am assuming your type and revenue_type__c field is picklist field and please also check our picklist values API name from field definition. Hope this will help, Thanks Show MoreWrite an answer...BoldItalicUnderlineStrikethroughBulleted ListNumbered ListAdd linkCode blockInsert imageAttach filesLink URLCancelSave0/9000Reply
Accepted AnswerMadan Lal Bakoliya (Salesforce)Mar 23, 2020, 8:34 PMTry this:AND( OR( ISPICKVAL( type, "incremental only" ), ISPICKVAL( type, "renewal with incremental" ) ), ISPICKVAL(revenue_type__c,"New"), ISBLANK(TEXT(change_type__c))) I am assuming your type and revenue_type__c field is picklist field and please also check our picklist values API name from field definition. Hope this will help, Thanks Show More