select case

[Dukester0122]

i have a formula but everytime i save it i get an error.

select case {table.001}

case "PD10", "PD10-80"
FORMULA = 'PD'

case "CX10"
FORMULA = 'CX'

END SELECT

 

[lbass]

In Crystal syntax it would be:

select {table.001}
case "PD10", "PD10-80" : 'PD'
case "CX10" : 'CX'
default : ""

-LB

 

[Dukester0122]

maybe i was using the wrong formula then because what i want to do is group "PD10" and "PD10-80" to 'PD' and "CX10" to 'CX'.

which formula do i need to use?

 

[Dukester0122]

you're right. it did group in 'PD' and 'CX'. Thanks