Skip to main content
Jeff King preguntó en #Formulas

I am trying to write a formula that says if an opportunity is closed won and the bookings recognized date was after a certain point than do one thing otherwise return zero. This formula worked as an IF statement, but it stopped working as an if and statement. The error I get is:

"Warning

Error when encoding row-level formula: Incorrect parameter type for function 'AND()'. Expected Boolean, received Number"

 

This is the formula:

if(AND(OpportunityLineItem.Opportunity_Stage__c = "6-Closed Won", Opportunity.Book_Recognized_Date__c >= datevalue('2024-01-01'),(OpportunityLineItem.Annual_Bookings_Amount_R_W__c.CONVERT - if(isblank(OpportunityLineItem.Partial_Growth_Amt__c.CONVERT),0,OpportunityLineItem.Partial_Growth_Amt__c.CONVERT)),0))

4 respuestas
0/9000