Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
hi find attachment
It seems correct to me, could you post a qvw?
How are those variables set into your app?
SET ThousandSep='.';
SET DecimalSep=',';
SET MoneyThousandSep='.';
SET MoneyDecimalSep=',';
SET MoneyFormat='R$ #.##0,00;-R$ #.##0,00';
Attached is the sample qvw
hi find attachment
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
Hi Prem,
can u pls post the procedure for me.
regards
Mahesh
Thanks Allan...
hi mahesh,
you have to just choose money radio button in >Number tab> Money