if then else question 2

[GuyHamasaki]

I get the following message in the Crystal formula editor: "A number is required here."

This the formula causing this message.

if A = 'Other' then
B
else
C

Is it possible to conditionally display text data?

Regards,

Guy

 

[Ngolem]

yes but both B and c must be text strings...if one or the other is not then convert the number (or date) one to a text format using:

ToText(B) or ToText(C) depending on which was the number.

In general, B and C must be the same data type...ie both are either Boolean, number, string or date types

Jim

 

[GuyHamasaki]

That was the problem. One of the fields is not text. The real issue is the datasource for the report in an excel spreadsheet. I checked to see if both fields were text fields and they were. Regardless, thanks for the assistance on this one.

Guy