Removing decimals from field value = 0 1

[junction123]

Hi

I am using CE 9 and Sybase 12.x

I have a field (Shares) that has a combination of values and 0. The zero value should have no decimal.

For example

3970.821
0.000

I managed to format the field value that has 0.000 to 0 by choosing "Show zero values as 0". However eventhough the field is right aligned, it does not align correctly with the other values.

For example I get :

3970.821
0

when I should have

3970.821
0

Thanks!
junction123

 

[synapsevampire]

Right click and select Format Field->Number->Customize->X 2 next to decimals and place:

If {table.field} = 0 then
0
else
3

-k