Missing data show as ....

Looker Q&A Looker Studio
1

Hi

I have a scorecard measuring revenue. I have missing data set to “show 0” … I need it to show as £0, as it feeds into other charts which now aren’t calculating correctly.
Any ideas how to make this happen?

Thanks – MIKE

2

Hi,

You can add the pound sign as an image and not format the number directly.