Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi
Share your current currency vale, how it is looking and how you want to display.
Regards
Tripati
Hi Bhargav:
Are you try to modify de format mask of the expresion?
Best Regards,
Juan P. Barroso
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.
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
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
Perhaps this?
=Num(Round(Measure/1E9, 0.1),'## Billion')
Hi
num(numberField/1000000000,'##.#0 Billion')
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])