Round Off

[noman212]

Dear All,

I have a no two nos.

2147 and 2933

I want to round of 2147 to 2000

and 2933 to 3000 Please assist.

Regards

Noman khan

[Chanty4u]

   Floor(Num('EXPRESSION'))

[Anonymous]

try with Floor() & Ceil()...

how it is stored into data??

[amit_saini]

Hi,

Check:

https://community.qlik.com/message/254814#254814

https://community.qlik.com/message/760272#760272

Thanks,

AS

[tresesco · Accepted solution]

Round(YourNumber, 1000)

[sunny_talwar]

Try this:

=Round(Number/1000)*1000

[Chanty4u]

=num(round(urnum))

[noman212]

Thanks Alot tresesco

[Chanty4u]

hi,