I am working on a Row-Level report formula, and I keep getting a Missing ')' error on this formula. I've tried looking online for tips but I'm still missing something.
I played around with it, so I might've made it worst. I am trying to create a validation field for various conditions.
Here's what I have:
If(Churn_Event__c.Effective_Date__c > TODAY(),
If( OR(
IF(AND(
(ISPICKVAL(Churn_Event__c.Save_Successful__c, "yes")),
Churn_Event__c.Total_Amount_of_ARR_Churned__c < Churn_Event__c.Churned_Revenue__c)
"Yes",
IF(AND (ISBLANK(Churn_Event__c.Save_Successful__c)),
Churn_Event__c.Total_Amount_of_ARR_Churned__c = Churn_Event__c.Churned_Revenue__c)
"Yes",
IF(AND (ISPICKVAL(Churn_Event__c.Save_Successful__c, "no")),
Churn_Event__c.Total_Amount_of_ARR_Churned__c = Churn_Event__c.Churned_Revenue__c)
"Yes",
),
),
"No"),
"No")
Hi Tarah,
I have reviewed the Row-Level Formula and identified the issue with the formula structure. The IF() statements were being used inside the OR() condition, which was causing the “Missing )” error.
I have restructured the formula to validate the required conditions correctly:
IF( Churn_Event__c.Effective_Date__c > TODAY(), IF( OR( AND( ISPICKVAL(Churn_Event__c.Save_Successful__c, "yes"), Churn_Event__c.Total_Amount_of_ARR_Churned__c < Churn_Event__c.Churned_Revenue__c ), AND( ISBLANK(Churn_Event__c.Save_Successful__c), Churn_Event__c.Total_Amount_of_ARR_Churned__c = Churn_Event__c.Churned_Revenue__c ), AND( ISPICKVAL(Churn_Event__c.Save_Successful__c, "no"), Churn_Event__c.Total_Amount_of_ARR_Churned__c = Churn_Event__c.Churned_Revenue__c ) ), "Yes", "No" ), "No" )
This formula returns
“Yes” when the Effective Date is in the future and any one of the three defined conditions is met. Otherwise, it returns “No.”
