Truncating numeric fields by thousands

[Former Member]

Hi,

I wish to know how to truncate numeric fields by thousands. Suppose a field is 68,312 then I need to display in 1,000's and make it appear as 68. I checked within Format Field -> Number -> Customize and did not find anything that serves the purpose. Any clue regarding this ?

Regards,

Ray.

[former_member292966 · Accepted solution]

Hi Amogh,

Try this:

Int ({TABLE.FIELD} / 1000);

This will round to the closest number. So if you do not want it to round you'll need to play with it a bit more.

Good luck,

Brian

[Former Member]

Can you please briefly explain how exactly you are looking the data to be displayed?

[Former Member]

use function and divide it by 1000.

Raj