AdWords is now Google Ads. Our new name reflects the full range of advertising options we offer across Search, Display, YouTube, and more. Learn more

Data Studio
4.2K members online now
4.2K 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.