function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
cldavecldave 

Case formula returning in #error!

Hi I have a simple case formula to group different formula fields depending on Record type.

In some case it returns the data properly and in other cases it does not even tho those 2 records meet same criterias.

Looking at those fields indivudually, none of them result in an error , only when grouped using case formula do i get error.

Here's my formula:
CASE(RecordType.Name, 
"M.C.A Layout", 
"Eff. MCA Balance" & ": $" & Text (ROUND(  Effective_Anticipated_Balance_MCA__c  ,2))& BR() & 
"Eff. Date Client will have paid 60% :" & Text (  Effective_Ant_Callback_Date_60_MCA__c  ), 
"Daily ACH Layout", 
"Eff. Daily Balance " &": $" & Text (ROUND(  Effective_Anticipated_Balance_Daily__c ,2))& BR() & 
"Eff. Date Client will have paid 60% :" & Text (  Effective_Ant_Callback_Date_60_Daily__c ),
"None")

If I remove  the case formula , saving field with just 1 group or the other , results show up fine.

Example: "Eff. MCA Balance" & ": $" & Text (ROUND(  Effective_Anticipated_Balance_MCA__c  ,2))& BR() & 
"Eff. Date Client will have paid 60% :" & Text (  Effective_Ant_Callback_Date_60_MCA__c  )  RETURNS PROPER RESULT WHEN SAVED

Example 2: "Eff. Daily Balance " &": $" & Text (ROUND(  Effective_Anticipated_Balance_Daily__c ,2))& BR() & 
"Eff. Date Client will have paid 60% :" & Text (  Effective_Ant_Callback_Date_60_Daily__c ) RETURNS PROPER RESULT WHEN SAVED

But together using both in a case formula fails.... I'm lost

Please help


Thank you in advance
Abhi_TripathiAbhi_Tripathi
You have to check weather your FIELDS are having values or not, so for that you have to use IF condition as I am doing

//Check for the first formula value do the same for other in single formula field

IF(  
AND (Effective_Anticipated_Balance_MCA__c  != NULL, Effective_Ant_Callback_Date_60_MCA__c   != NULL),

"Eff. MCA Balance" & ": $" & Text (ROUND(  Effective_Anticipated_Balance_MCA__c  ,2))& BR() & 
"Eff. Date Client will have paid 60% :" & Text (  Effective_Ant_Callback_Date_60_MCA__c  )   ,

0
)

Hope this helps