I have a formula to calculate renewal upsell only if the Previous Renewal lookup isn’t blank. I want it to also only run if Type (picklist) = Renewals.
IF(OR(NOT(ISBLANK(Previous_Renewal__r.Name)), ISPICKVAL(Type,"Renewals")),Annual_Recurring_Revenue__c - Previous_Renewal__r.Annual_Recurring_Revenue__c,NULL)
The syntax is fine, but it’s still running for other Types. Can anyone provide insight why?