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))
@Jeff King it's works Let me know if any issue