You need to sign in to do that
Don't have an account?
cldave
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
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
//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