When saving "Total_Point_Percentage__c" I get the error "Compiled formula is too big to execute (6,243 characters). Maximum size is 5,000 characters (Related field: Formula)"
Is there an alternative way of calculating this or a way of reducing the size to under the max of 5,000?
- Filed1 - Picklist - Yes,No
- Filed2-10 - Picklist - 1-10
- Filed11-13 - Picklist - 1-5
- Total Points - Formula
- Percentage Total - Formula
- Total Point Percentage - Formula
Total_Point__c
IF(ISPICKVAL(Field1__c,'Yes'),
VALUE(TEXT(Field2__c)) +
VALUE(TEXT(Field3__c)) +
VALUE(TEXT(Field4__c)) +
VALUE(TEXT(Field5__c)) +
VALUE(TEXT(Field6__c)) +
VALUE(TEXT(Field7__c)) +
VALUE(TEXT(Field8__c)) +
VALUE(TEXT(Field9__c)) +
VALUE(TEXT(Field10__c)) +
VALUE(TEXT(Field11__c)) +
VALUE(TEXT(Field12__c)) +
VALUE(TEXT(Field13__c)), 0 ) +
IF(ISPICKVAL(Field1__c,'No'),VALUE(TEXT(0)), 0)
Percentage_Total__c
IF (ISBLANK(TEXT(Field2__c)),0, 10) +
IF (ISBLANK(TEXT(Field3__c)),0, 10) +
IF (ISBLANK(TEXT(Field4__c)),0, 10) +
IF (ISBLANK(TEXT(Field5__c)),0, 10) +
IF (ISBLANK(TEXT(Field6__c)),0, 10) +
IF (ISBLANK(TEXT(Field7__c)),0, 10) +
IF (ISBLANK(TEXT(Field8__c)),0, 10) +
IF (ISBLANK(TEXT(Field9__c)),0, 10) +
IF (ISBLANK(TEXT(Field10__c)),0, 10) +
IF (ISBLANK(TEXT(Field11__c)),0, 5) +
IF (ISBLANK(TEXT(Field12__c)),0, 5) +
IF (ISBLANK(TEXT(Field13__c)),0, 5)
Total_Point_Percentage__c
Total_Point__c / Percentage_Total__c * 100