3 answers
Hello Denise,Try replacing all those AND/IFs with CASE like below :
And see if that works.Note: Mark this as solution if it helps!Cheers,KVinCASE(Product_Probability__c,
10%, (TotalPrice / 12) * 0.10 * (13 - (MONTH(Product_Close_Date__c))),
15%, (TotalPrice / 12) * 0.15 * (13 - (MONTH(Product_Close_Date__c))),
20%, (TotalPrice / 12) * 0.20 * (13 - (MONTH(Product_Close_Date__c))),
40%, (TotalPrice / 12) * 0.40 * (13 - (MONTH(Product_Close_Date__c))),
75%, (TotalPrice / 12) * 0.75 * (13 - (MONTH(Product_Close_Date__c))),
100%,(TotalPrice / 12) * 0.100 * (13 - (MONTH(Product_Close_Date__c))),
"0")
Yes, thank you for the quick response. You are correct - there is a syntax error in the suedo code. Still trying to get that worked out.