You need to sign in to do that
Don't have an account?
Aravind R
Compiled formula is too big to execute
I have a formula field "Solutions TAT" which is of 4500 compiled characters.
I have another formula field as below which is giving compiled formula is too big to execute error as I am referring "Solutions TAT" twice which is a big formula field:
IF( Solutions_TAT__c > Target_Completion_Days_Solutions__c , 'RED'
IF(Solutions_TAT__c < (Target_Completion_Days_Solutions__c * 0.7), 'GREEN',
'AMBER'
)
)
Please suggest some workaround to overcome this. Thanks in advance.
I have another formula field as below which is giving compiled formula is too big to execute error as I am referring "Solutions TAT" twice which is a big formula field:
IF( Solutions_TAT__c > Target_Completion_Days_Solutions__c , 'RED'
IF(Solutions_TAT__c < (Target_Completion_Days_Solutions__c * 0.7), 'GREEN',
'AMBER'
)
)
Please suggest some workaround to overcome this. Thanks in advance.
Try using the formula in Solutions_TAT__c and use it in this formula to get the value that you want, or use a workflow with a field update to populate the field you are trying to work with.
Thanks
Anand
All Answers
Try using the formula in Solutions_TAT__c and use it in this formula to get the value that you want, or use a workflow with a field update to populate the field you are trying to work with.
Thanks
Anand