Re: Crystal XI- IF statment, New user
- From: "Briscobar" <youcant@xxxxxxxxxxxxxx>
- Date: Mon, 24 Apr 2006 13:40:56 -0400
Cristina Andreozzi <cca3340@xxxxxxxxxxxxxxxx> rambled:
I've scoured the internet but have had no luck so here I am showing my
ignorance.
I have a field that returns numbers. I want to have the same field
return a word, based on the number:
If "1" returns then I want the field to show "hello"
If "2" returns then "goodbye"
Etc.
I've seen plenty of statements talking about "less then" and "greater
than," but nothing like what I want. I'm guessing because what I want
to do is so simple.
Any help would be appreciated!
Create a formula:
//NumberToText Formula
if {table.field} = 1 then "hello" else
if {table.field} = 2 then "goodbye"
Of course, if the field is "3", then it's going to go haywire. If there are
only two possible outcomes (1 or 2), then the above formula shoudl work
fine.
--
KB
MCNGP #26
www.mcngp.com = t3h h0tn3ss
.
- References:
- Crystal XI- IF statment, New user
- From: Cristina Andreozzi
- Crystal XI- IF statment, New user
- Prev by Date: Crystal XI- IF statment, New user
- Next by Date: Re: Crystal XI- IF statment, New user
- Previous by thread: Crystal XI- IF statment, New user
- Next by thread: Re: Crystal XI- IF statment, New user
- Index(es):
Relevant Pages
|
