Remove zeros from a number 1

[infotech2]

I have a database that stores some order numbers like this: 2301.000, 2301.001, 2301.002, etc. The .001 means the original service needed follow up. The only way I can find to display this number in Crystal is by formatting the number in this format: 0000.0000 so it shows up like this: 2301.0000, 2301.0010.

I have to come up with a method to count the number of services considered follow up. I'd like to convert all the numbers to this: 2301, 2301.1, 2301.2, etc. Then I could create a formula that counts all of the services that have a decimal, or something like that.

Is there a way to convert the numbers to that format?

 

[briangriffin]

Give this a try:

whileprintingrecords;
numbervar x := instr(totext({yourfield},"#.###",3),".") - 1;;
stringvar y := totext({yourfield},"#.###",3);

tonumber(left(y,len - x) + replace(right(y,len - x),"0",""))

 

[IanWaterman]

This work as long as you do not get as high as
2300.010 if you do some extra logic will be required.

@service
local numbervar fup:= int(tonumber('2301.001')*1000)- int(tonumber('2301.001'))*1000;

if fup = 0 then totext(int(tonumber('2301.001')),0,"")
else
totext(int(tonumber('2301.001'))+(fup/10), 1,"")

Replace '2301.001' with

totext(yourordernumber,3,"")

Ian

 

[infotech2]

Thank you both for the quick response.

Brian - I tried yours and it removed the decimal completely.

Ian - I get "The remaining text does not appear to be part of the formula" for Replace to the last ).

Thanks Again!

 

[infotech2]

Holy crap I'm a moron. Ian - That worked great. I just need another cup of coffee.

 

[lbass]

Why not just create a formula like this (if it is true that ANY decimal other than 0 means a followup is required)?

if int({table.number}) = {table.number} then
0 else 1

Insert a sum (NOT a count) on this formula.

-LB

 

[infotech2]

lbass - Thanks for the suggestion. I also wanted a way to show the numbers without the zeros so they are more readable.