Making one word into another (last question today I promise)

[Yustrn]

O.K,

Let's say I have 4 different departments

Sales
Management
Executive
High Level Exc


I'm looking for a formula for when it come accross the word Sales it makes that Department one, Management would be Department 15, ect ect....what can I use for this? This is Crystal 7

 

[lbass]

You can use an if-then:

if {table.department} = "Sales" then 1 else
if {table.department} = "Management" then 15 else
if {table.department} = "Purchases" then 25 else
0

-LB

 

[lbass]

If you want the results to be strings, enclose the numbers in quotation marks.

-LB