Can you attache the twbx file?
It's easiest to use Tableau's default number formatting.
1. Right-click on Trans (under Measures) and choose Default Properties --> Number Format.
2. Select Currency (custom).
3. Set it to 3 decimal places and Units: Billions.
4. Click 'OK'
5. Edit your labels to remove '/1000000' (this is just a text label, not a calculation).
Stock171105_v10.2.twbx 814.2 KB
Thank you Branden, that is what I want.