Number formatting

[#1]

can any suggest me how to format numbers

for ex:- i have 45.5643678541315

I just want to round up to 3 decimal after .

like  45.564

I tried this expression =Sum((vAnnualusage), '##.##0')

[MK_QSL]

Num(YourFieldName,'#0.000') as YourFieldName

=NUM('45.5643678541315','#0.000')

=NUM(Sum((vAnnualusage),'#0.000'))

[anbu1984]

=Sum((vAnnualusage), '##.###')

[#4]

Hi ,

Try this ,

=num(sum(vAnnualusage),'##.###')

should work !!

Regards

Sahil

[MayilVahanan]

Hi

Try like this

Num(Sum($(vAnnualusage)), '##.###')

Hope that vAnnualusage is the variable name.

[#6]

Hi,

Try like the following..

round(num(Sum($(vAnnualusage))), 0.001)

Hope it will work..

[#7]

Thanks Sahil it's work like a magic

Thanks

Amzad

Thank for Quick response Manish, anbu, Rama

[#8]

Yes shail it work SuperB, Thanks

[its_anandrjs]

Hi,

You have to use Round function

=Round('45.5643678541315', 0.001 )

or

=Round( Sum(vAnnualusage), 0.001 )

Regards

Anand

[#10]

Thanks Anand, it's work..