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.3K members online now
4.3K members online now
Ask questions about Data Studio
Guide Me

calculate share of a value

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hi studio community,

Id like to calculate the share of a value and add it in a table or also use it in bar charts etc.

I am not able to get the right formula. 


Just to make it more clear: 

question studio.PNG







Available is revenue per date.

When I add a table on the dashboard I also want to create a column with the share of the value  (red in Excel). 

No matter what kind of formula I am trying an error message like this pops up.


question studio 2.PNG



Anybody an idea for another formula or a different way?


Thanks a lot!