I'm trying to create a process builder, but I'm stumped on the Define Criteria section.
We have a checkbox field called 'Discount_Approved__c' which is checked by an approval process.
I now need that field to be unchecked, if the value of the 'Opp_Discount_Pct__c' formula field increases, from its previous value.
I currently have the below, but when the value of 'Opp_Discount_Pct__c' increases the 'Discount_Approved__c' isn't becoming unchecked.
AND(
[ADvendio__MediaCampaign__c].Discount_Approved__c,
ISCHANGED([ADvendio__MediaCampaign__c].Opp_Discount_Pct__c ),
PRIORVALUE([ADvendio__MediaCampaign__c].Opp_Discount_Pct__c) < [ADvendio__MediaCampaign__c].Opp_Discount_Pct__c
)
Any thoughts, what I'm missing?
Thank you
Leon
5 answers
Hi Leon,
ISCHANGED function doesnt work with formula fields, that is why your PB was not working.
