How to convert dimention in Million formate ?

[#1]

Hi,

I am new to qlikview.

I have a dimention which needs to convert into million formate.

Example :

202,000,000

I want to show this  as

$202M

How can we show this in above formate ?

Thanks!.

[maxgro]

maybe

=num(202000000/1000000, '$#.##0M')

for format ('$#.##0M') go to number tab in the chart

[#3]

thanks.

we does not show decimal place

how can we show number without decimal place ?

[santharubban]

=num(202000000/1000000, '$###0M')

[#5]

thanks it works.

[santharubban]

can mark this correct answer and close the thread.

[maxgro]

go to number tab and play with format

when you get the format you want, copy in the num function

[MarcoWedel]

See also

how to enable the billion and trillian format

Hope this helps

Regards

Marco