Here is the current formula:
IF( AND
(NOT
(Line_Level_Detail__c ='Services'), Line_Level_Type__c= 'New Product'), UnitPrice * Quantity , 0)
Trying to add criteria that says if the Opportunity Stage is Closed Lost then the results should be 0.
This formula sits on the opportunity product.
This is what I have right now:
IF(ISPICKVAL(Opportunity.StageName, "Closed Lost"), 0, AND
(NOT
(Line_Level_Detail__c ='Services'), Line_Level_Type__c= 'New Product'), UnitPrice * Quantity , 0)
Can't figure out where we are going wrong.