Hello everyone! Can someone explain to me why the formula is not working?

SUM(New followers) / SUM(Profile Views) * 100

I have already checked all the questions but the error “no data” always returns to me

Details:
SUM(New followers) → Working!
SUM(Profile Views) → Working!
SUM(Profile Views) * 100 → Working!
SUM(New followers) * 100 → Working!

SUM(New followers) / SUM(Profile Views) * 100 → not working
SUM(New followers) / SUM(Profile Views) → not working

Tkss!

Hi
what type of data source are you using?

Hi @matheusl3 . Do you have Looker Studio Pro? If so, you may also want to try out our new Formula Assistant (https://cloud.google.com/blog/products/business-intelligence/ai-powered-slide-generation-and-formula-assistant-in-looker) to see if this helps write the correct formula for you.

Let us know if this helps!