Converting Expression Values into currency standard

[Anonymous]

Hi,

I have a value $1,211,325,588.00 as the currency value in the along with other columns in the table. But i am not able to format it to standard currency representation with Thousands, Millions or Billion separators. They are graded out. Could any one help me on this formatting?

Thanks in advance.

[tripatirao]

Hi

Share your current currency vale, how it is looking and how you want to display.

Regards

Tripati

[jubarrosor]

Hi Bhargav:

Are you try to modify de format mask of the expresion?

Best Regards,

Juan P. Barroso

[Anonymous]

Hi Sir,

Currently the value is $1,211,325,588.00. I want to make it as 1.2 Billion is such formats. I have many such columns in the table to convert to. I tries the properties -> Number and format there. The options are grayed out.

I am working in Qlikview Desktop.

[Anonymous]

Hi Sir,

Currently the value is $1,211,325,588.00. I want to make it as 1.2 Billion is such formats. I have many such columns in the table to convert to. I tries the properties -> Number and format there. The options are grayed out.

I am working in Qlikview Desktop.

Regards,

Bhargav

[PrashantSangle]

did you select override Document setting in number property???

can you share screen shot of it.

also you can use num(numberField/10000000,'#.##')& ' Billion'

Regards

[Anil_Babu_Samineni]

Perhaps this?

=Num(Round(Measure/1E9, 0.1),'## Billion')

[Anonymous]

[Anonymous]

Hi

num(numberField/1000000000,'##.#0 Billion')

[sasiparupudi1]

You have to do this in the script. may be using a dual something like this

Dual(Num(Round(1211325588.00 /1000000000,0.1),'## Billion'),[number field])