My friend Diogo Martins, told me a simple but powerful custom formatting to numbers that can help you so much!
Here is the tip:
Think that you have a Profit metric with a number like this: 1.304.141
And you want to divide that by 1000.
You just have to:
- Format the value and go to Custom
- Add a format like: 0,
And now you will get your number like: 1304
The trick is the comma (,) at the end.
If you add 1 comma you will dividing by 1.000
If you add 2 commas you will dividing by 1.000.000
And so on…
So, just add commas after the 0 (for number) and you will format your number in a much better way than dividing it in your metric.
Hope it helps!
God bless you!