Maximum Calculated field formula length
Does anyone know if there is a maximum length the formula for a calculated field can become?
I have a formula that is currently 3855 characters long and consists of a CASE formula with many WHEN clauses. I don't get any errors when I update the calculated field.
However on the report, I get incomplete results from the calculcated fields. It looks like only the first 5 WHEN conditions are evaluated.
I have verified my WHEN clauses are correct by removing all other clauses, and refresh the report. I get results as expected when I do that.
So the only thing I can think of, is a maximum length the formula can become, as I have other calculated fields with many WHEN clauses and they work without issue.
Sadly there is nothing to be found in the documentation.