Formatting numeric values

Classic Servoy
1

Hi,

I would like to know if the following is possible using just a format:

I have a database column numeric (9, 4)

By default this value is shown as #0,0000

But I would like to know if I can show the following, just with a standard format function:

123,4567 must show 123,4567
123,456 must show 123,456
123,45 must show 123,45
123,4 must show 123,40

and in another particular case I want:

123,0000 be shown as just 123
123,5000 be shown as 123,5

I’ve seen in Jasper some function RemoveTrailingZeroes but that makes it 1235E-01 and that is also not what I want.

Is there some default format that can make this format?
Of course I can write a method in a calculation to show the exact format I want, but I don’t want to do this.

Anyone has any idea?

Thanks

Martin

2

Hi Martin,

Just change the formatting from #0,0000 to #0,#####.

3

Thanks Robert,

That is exactly what I needed.

Martin