Num Conversion

[#1]

Hi,

the below expression is returning for eg 120

=num(sum([Jun 30, 2013 - Jul 06, 2013 - Rev]),'$#,##0 K')

in dta labels i want it to be displayed as $ 120 k......how the above expression should be modified for that?

Thanks

[Clever_Anjos]

It seems correct to me, could you post a qvw?

[Clever_Anjos]

How are those variables set into your app?

SET ThousandSep='.';
SET DecimalSep=',';
SET MoneyThousandSep='.';
SET MoneyDecimalSep=',';
SET MoneyFormat='R$ #.##0,00;-R$ #.##0,00';

[#4]

Attached is the sample qvw

[preminqlik · Accepted solution]

hi find attachment

[rustyfishbones]

PFA,

it works using

NUM(sum([Jun 30, 2013 - Jul 06, 2013 - Rev]),'$,##0 K')

I think in the numbers tab you were not choosing Expression Default

like below

[#7]

Hi Prem,

can u pls post the procedure for me.

regards

Mahesh

[#8]

Thanks Allan...

[preminqlik]

hi mahesh,

you have to just choose money radio button in >Number tab> Money