Recently I have started getting ‘Invalid formula’ on every formula I try.
Even when I edit and don’t change anything in an existing formula.
Even when I only put a dimension, or only put a metric (ie not do any actual calculations) in a formula… it is still showing me Invalid formula.
This seems weird. I’ve used Looker Studio extensively and it just started doing this a month ago.
It seems like it’s happening in Blends. It’s happening across reports. Again the weirdest part is when I ‘edit’ a current calculated field, but don’t actually make any changes, and it gives me the error. Or just putting a single value. So weird.
I’m having the same problem, with Blended Data Sources. It seems the callback to the server to validate the formula is throwing an error, the response at the moment appears to be malformed, and the validation it’s doing seems to bear no correlation to the formula I have.
I have a blended data source pulling the revenue from our systems and the google ads spend from the google ads connector. With a custom formula that contains just the total revenue I get the following. the blended data source includes cost per conversion from the source data adapters, which I think is causing this translated SQL error - despite those fields not being in the formula.
)]}'
{"errorStatus":{},"errorMessage":"UNKNOWN","status":{"code":2,"space":"generic","message":"Invalid input expression. - Multiple levels of aggregation.:SELECT SUM(SUM(t0c0d2.Spend) / SUM(t0c0d2.Conversions)) AS alias FROM t0c0d2;"},"connectorErrorStatus":{}}
Removing that field from my blend resolved, now, I kind of wanted that in the blend, so I now have two versions of the blend, one for the formula that don’t use that field and others that are only using those fields in a table where it works ok.
But it used to work so this feels like a bug that needs fixing.
Hi Abhishek + Federico, it seems like many users are having this issue/bug recently. I see you are administrators. Can someone at Google please help? We are stuck.
@Anthony_Blatner - the multiple replies will be removed as they are duplicated. You only need to escalate once if you feel it’s not getting attention. The Looker Team does monitor the forums.
Hi everyone, thanks for reporting this issue. I’ve filed a bug and have our team looking at this issue. I’ll post an update as soon as I have more information.
Hi @EdgarA checking in to see if you have any more info you can share or a timetable for this being addressed?
This issue affects every formula in a Blend, which is a very commonly used functionality in Looker Studio. I imagine it must be a big widespread issue.
Hi @EdgarA , I’m also experiencing this same issue. I get “Invalid Formula” on every calculated field I try to add to a chart that uses a Blend as its data source. It’s impacting my ability to deliver reports for partners. I would also like to inquire about this issue and request an update on this investigation. Thank you!
