convert data v 8.5

[tomk01]

Hello All,

I want to convert data inside of a string. so, I have a formula that converts the data to text and I cant get rid of the decimel.

I have a number field that looks like this:
.00010
.00297
.00497
I want to data to be in a string and look like this:
00010
00297
00497
Here is my formula that does not work:

stringvar rateAsString := totext({SCTax.overrideTaxRate}*100,00000,"")

My output is:
00000
00003
00005

 

[synapsevampire]

Just use:

replace(totext({SCTax.overrideTaxRate}*100,00000,"")".","")

-k

 

[lbass]

Try:

totext({SCTax.overrideTaxRate}*100000,"00000")

-LB

 

[synapsevampire]

Ooops, I meant the following, but LBs looks cleaner, use that:

replace(totext({SCTax.overrideTaxRate},00000,0,"")".","")

-k