Format a number within a text string 1

[DilbertAsok]

Using the formula:

IF {XXX.XXX} = "2 NYS" THEN "Not yet started:  "&DistinctCount ({XXX}, {XXX.XXX}) ELSE

[formula then continues with other IF statements]

The output of the above line looks like:

"Not yet started: 7.00", but as the output will always be an integer the decimal places are not needed.

As the output is a text string I cannot remove the decimal places using the normal formatting. Is there a way around this?

Thanks,

 

[lbass]

IF {XXX.XXX} = "2 NYS" THEN "Not yet started: "& totext(DistinctCount ({XXX}, {XXX.XXX}),0,"") ELSE

-LB

 

[DilbertAsok]

Perfect - thanks!

I was sure it was something around totext or tonumber but couldn't fix the conditions at the end!

 

[SkipVought]

DilbertAsok,

Welcome to Tek-Tips.

No doubt you have noticed the [purple]little purple Stars[/purple] as you browsed this forum. In this thread, in the lower left-hand corner of each post, is a link that states...

[blue]
Thank Tek-Tip Contributor
for this valuable post![/blue].

The [purple]little purple Stars[/purple] accomplish several important things.

First, it gives positive feedback to contributors, that their posts have been helpful.

Second, it identifies threads as containing helpful posts, so that other members can benefit.

And third, it identifies the original poster (that's YOU, BTW), as a grateful member, that not only receives, but is willing to give tokens of thanks.

Please use this [purple]link[/purple] whenever appropriate.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}