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

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.