truncating a real to an int

[woohoo]

've got a field object that is a formula, which works great and all.

the end result is a real number and i want to just truncate it into an int. how does one do this?

thanks

 

[Ngolem]

truncate({table.number},0) Jim Broadbent

 

[Naith]

Like the man said.

Or right click on the field, Number tab, Customize buttom, set Decimals to 1.

Naith

 

[Naith]

D'oh.

I just remembered that you can't set get rid of your decimals without implicitly rounding up the integer.

Do what Ngolem said.

Sorry about the misadvice.

Naith

 

[woohoo]

thanks for the help; to extend on that a bit, how does one set it so that the trailing zero's aren't shown?

 

[woohoo]

bags! i look away for a second and the advice i need is already there

thanks ya'll