Format Thousands

Is there a way to format a numeric value so that it displays in thousands?
(E.g. In excel if you wanted the number 100,000,000 to show up as 100,000 then you would format it as #,##0, with a trailing comma. It didn't work in eclipse.)

Find more posts tagged with

Comments

JoshiS

when you select your data row, you can use Property Editor where selecting format Number will allow you to format your number as all possible option as fixed, currency, scientific etc. with Use 1000 separator check option

ruve1k

I am aware that you can use a comma as a thousands separator. That is not what my question was. I want to display 10,000 as 10. This can be done in excel as I delineated above. Is there a way to do this in eclipse-BIRT?

mwilliams

Hi ruve1k,

I haven't tried to do so with a format pattern like that. However, you could just create a computed column or just modify your data element to display row["value"] * .001. If I figure anything out with the format pattern, I'll post it in here.