Text in a numeric field 1

[AkronBoy]

How do I put "TBD" into a numeric field when the value is 0.
Example of report fields would look like:
8
5
TBD
6

 

[mbarron]

Crystal won't allow different types of results (string, number, boolean, date, etc) for one field.

If you don't want to use the numbers in a calculation you can use:

if {your#field}= 0 then "TBD" else
totext({your#field},0,"&quot

Or, if you want to be able to use the numbers you can create two fields placed on top of each other. Problems will occur if you use most of the summary operations other than sum and maximum. Anything that uses a count of the items to calculate, such as average, will give you bad results.

For the number field, conditionally suppress it using:
{your#field}=0

Fot the TBD, create a string field with "TBD" in it. Then conditionally suppress it using:
{your#field}<>0





Mike
If you're not part of the solution, you're part of the precipitate.