trying to get decimals to disappear in a formula field 2

[lsgtechuser]

I have a formula field that does some multiplying and adding with different fields that are integers and then adds text to the end. the numbers always appear with a .00 at the end. is there any way to stop this from happening? I tried truncate, but that didn't work.

 

[synapsevampire]

Use totext({table.field,0,"")

The zero says the decimal places, the "" is the thousands separator, in this case nothing.

-k

 

[satinsilhouette]

Try this in your forumula:

ToText(12345.4999,0)
Returns "12345"

 

[lsgtechuser]

thanks again for the help

 

[rosemaryl]

Dear All,

Another toText option is Totext({@fieldorformula},'#')

The pound sign option means no decimals, no formatting!

The help is quite extensive and shows all kinds of formatting options. Do a search on Totext!

regards,

ro

Rosemary Lieberman
rosemary-at-microflo.com,

http://www.microflo.com

Microflo provides expert consulting on MagicTSD and Crystal Reports.

You will get answers more quickly if you read this before posting: faq149-3762