Skip to Content
0
Jun 22, 2009 at 03:55 PM

Rounding the amount field at thousand's level

523 Views

Hi ,

I have a currency field:

where I can values -


Need to show the values

1100.00 -- 1000.00

1600.00 -- 2000.00

5465.00 -- 5000.00

5999.00 -- 6000.00

11003.00 -- 11000.00

26798.00 -- 27000.00

Hope you got it, yes I need to round up the value at thousand level.

What is the better way other than mannual capturing of result.

Thanks,

Naveen Inuganti.