The Symbols in the Bar Chart do not change from Thousand to Millions

[Jack_Sayam]

Even though the value is in the millions the Bar Chart still shows the thousand symbol. The Bar Chart should display the appropriate symbol if it is millions or thousands. The Bar Chart shows the thousands symbol even though the value is in the millions.

My expression is:

money(sum({<Year = , Month=, [Matl Owner Ind]={'1'}>} $(eSales)), '$#,##0;('&'$#,##0)')

Any responses appreciated! THANK YOU!

[Claudiu_Anghelescu]

Check the format in the script, the tab MAIN
SET MoneyFormat='#.##0,00 $;-#.##0,00 $';