Data Studio
3.7K members online now
3.7K members online now
Ask questions about Data Studio
Guide Me

Maximum Calculated field formula length

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

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.