Skip to main content
Topics#Data ManagementDeba Harper's Question
Deba Harper (Detroit Land Bank Authority) asked in #Data Management
Dec 1, 2017, 6:19 PM

Error: Invalid Data. Review all error messages below to correct your data. Formula(s) that reference this field are no longer valid: Compiled formula is too big to execute (5,912 characters). Maximum size is 5,000 characters (Related field: Formula)

We are tracking activities within a 2 year cycle with a fixed date based on when the client enters the program year 1. Regular activity each month until the the end date the second year in the program. We have a formula field that calculates how many months the client must perform the monthly activity within the cycle, but we need a monthly calculation of how many months are remain in the cycle at a point in time each month. The months are over 2 years and the fields I am using are date record types (Date1 and Date2). Date1 is the date of the month we run a point in time analysis and Date2 is the date the client enters the program. The Result should be a increased number of months 1, which we are using to calculate how much money the client has saved to date.

 

Here is the formula I am using to calculate the number of months as the client activity occures while in the progam over a 2 year period.

 

IF(YEAR(Date1) = YEAR(date2), 

 

MONTH(Date1) - MONTH(date2), 

 

FLOOR((Date1 - Date2) / 30.25))

 

When I initialy built out the object with a few sample fields, this formula worked perfectly. Now I am getting an error message:

Error: Invalid Data. 

 

Review all error messages below to correct your data.

 

Formula(s) that reference this field are no longer valid: Compiled formula is too big to execute (5,912 characters). Maximum size is 5,000 characters (Related field: Formula)​
12 answers
Write an answer...
0/9000