Number format

[Mahamed_Qlik]

Hi all,

How to convert the following amount into two decimal correct number format ?

suppose  I have number as 153,050.00 (something like 1,53,050.00)

Regards,

mahamed

[MK_QSL]

If(FieldName < 1000, Num(FieldName,'#,##0.00'),Num(FieldName,'#,##,##0.00')) as FieldName

[Mahamed_Qlik]

Hey thanx buddy.

It works...!