Show in Millions instead of showing in Thousands.

[amithmurali]

Hi,

I want to show the values in my chart in Millions even when the values goes to the Thousands, like for "500,000". i want to show it as "0.5 M". can any one help me to achieve this.

[tresesco · Accepted solution]

Try like:  Num(YourExpression/1000000, '#,##0.##M')

Or similar format in the number tab with million division in th expression.

[amithmurali]

Thankyou tresesco for the idea. i have created a new field in the script by dividing it by 100,000 .