Help with IF statement

[terenceb]

Hi I using Crystal 8.5 pulling data from sql table on Cashe database.

My formula :

whileprintingrecords;
shared numbervar ProdUnits;
numbervar Mins := {tx_history_all.service_duration};
shared numbervar Units;


if ({@CPT Eligible} = 'Y' and {tx_history_all.SERVICE_CODE} in ['P102', 'P108', 'P109', 'P130', 'P131', 'P133' TO 'P139', 'P142', 'P208', 'P209', 'P9805', 'PM108', 'PM109', 'PM208', 'PM209'] AND {service_code_table.cluster_code} <> ['2','40','41']) then
(select {tx_history_all.service_duration} case 0 to 19 : Mins := 0
case 20 to 44 : Mins := 30
case 45 to 74 : Mins := 50
default : Mins := 80
else if ({@CPT Eligible} = 'Y' and NOT ({tx_history_all.SERVICE_CODE} in ['P102', 'P108', 'P109', 'P130', 'P131', 'P133' TO 'P139', 'P142', 'P208', 'P209', 'P9805', 'PM108', 'PM109', 'PM208', 'PM209'] AND {service_code_table.cluster_code} <> ['2','40','41'])) then
(Mins := {tx_history_all.service_duration}
else if {@CPT Eligible} = 'N' then
(select {tx_history_all.service_duration} case 0 to 14 : Mins := 0
case 15 to 29 : Mins := 15
case 30 to 44 : Mins := 30
case 45 to 59 : Mins := 45
case 60 to 74 : Mins := 60
case 75 to 89 : Mins := 75
case 90 to 104 : Mins := 90
case 105 to 119 : Mins := 105
case 120 to 134 : Mins := 120
case 135 to 149 : Mins := 135
case 150 to 164 : Mins := 150
case 165 to 179 : Mins := 165
case 180 to 194 : Mins := 180
case 195 to 209 : Mins := 195
case 210 to 224 : Mins := 210
case 225 to 239 : Mins := 225
case 240 to 254 : Mins := 240
case 255 to 269 : Mins := 255
case 270 to 284 : Mins := 270
case 285 to 299 : Mins := 285
case 300 to 314 : Mins := 300
case 315 to 329 : Mins := 315
case 330 to 344 : Mins := 330
case 345 to 359 : Mins := 345
case 360 to 374 : Mins := 360
case 375 to 389 : Mins := 375
case 390 to 404 : Mins := 390
case 405 to 419 : Mins := 405
case 420 to 434 : Mins := 420
case 435 to 449 : Mins := 435
case 450 to 464 : Mins := 450
case 465 to 479 : Mins := 465
default : Mins := 480
;

ProdUnits := Mins / 60;

Units := Units + ProdUnits;

ProdUnits;

Is skippign the secon dlevel of my If statement. When the {@CPT Eligible} = 'N'.

Help!!!

 

[pelajhia]

please give this a try; your problem may lie elsewhere, however.

if ({@CPT Eligible} = 'Y' )

then

( if {tx_history_all.SERVICE_CODE} in ['P102', 'P108', 'P109', 'P130', 'P131', 'P133' TO 'P139', 'P142', 'P208', 'P209', 'P9805', 'PM108', 'PM109', 'PM208', 'PM209'] AND {service_code_table.cluster_code} <> ['2','40','41'])
then
(select {tx_history_all.service_duration} case 0 to 19 : Mins := 0
case 20 to 44 : Mins := 30
case 45 to 74 : Mins := 50
default : Mins := 80
else
(Mins := {tx_history_all.service_duration}


)

else
(select {tx_history_all.service_duration} case 0 to 14 : Mins := 0
case 15 to 29 : Mins := 15
case 30 to 44 : Mins := 30
case 45 to 59 : Mins := 45
case 60 to 74 : Mins := 60
case 75 to 89 : Mins := 75
case 90 to 104 : Mins := 90
case 105 to 119 : Mins := 105
case 120 to 134 : Mins := 120
case 135 to 149 : Mins := 135
case 150 to 164 : Mins := 150
case 165 to 179 : Mins := 165
case 180 to 194 : Mins := 180
case 195 to 209 : Mins := 195
case 210 to 224 : Mins := 210
case 225 to 239 : Mins := 225
case 240 to 254 : Mins := 240
case 255 to 269 : Mins := 255
case 270 to 284 : Mins := 270
case 285 to 299 : Mins := 285
case 300 to 314 : Mins := 300
case 315 to 329 : Mins := 315
case 330 to 344 : Mins := 330
case 345 to 359 : Mins := 345
case 360 to 374 : Mins := 360
case 375 to 389 : Mins := 375
case 390 to 404 : Mins := 390
case 405 to 419 : Mins := 405
case 420 to 434 : Mins := 420
case 435 to 449 : Mins := 435
case 450 to 464 : Mins := 450
case 465 to 479 : Mins := 465
default : Mins := 480;