dollar value

[manoranjan_d]

Hi,

I m huge amount and low amount , i want to display the amount in dollars in stack back.

example: if we have 2120453 then it should show $2.12 in the stack bar chart inside plot segments, how to show this.

And also  above is an example amount ,another example amount which will more amount 2120453 or it can be 212045606 and another example it low amount.

how to show this?

[varshavig12]

Create an inline convert

Currency_Format:

LOAD * INLINE [

  Unit, Convert

   Actual,1

Thousand, 1000  

   Million, 1000000  

  Billion, 100000000

];

example:

If your expression is sum of stock:

sum(stock)/Convert

and then you can select any Unit.

This will reflect in your bar chart.