Case statement in SSRS

Question

Case statement in SSRS

komal145

SSCrazy Eights

Points: 9918
More actions
November 15, 2012 at 1:03 pm

#270908

Hi ...can anyone please tell me how to re-write the below case statement in SSRS?
CASE
WHEN ACTUAL_PERFOMANCE_MIN_BECHMARK > 0
THEN ACTUAL_PERFOMANCE_MIN_BECHMARK * 500
ELSE
CASE
WHENACTUAL_PERFOMANCE_TARGET_BECHMARK < 0
THENACTUAL_PERFOMANCE_TARGET_BECHMARK * 300
ELSE0
END
END
Thanks,
Komal

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Ray M SSC-Insane Points: 21093 More actions · Answer 1

CASE
WHEN ACTUAL_PERFOMANCE_MIN_BECHMARK > 0
THEN ACTUAL_PERFOMANCE_MIN_BECHMARK * 500
ELSE
CASE
WHEN ACTUAL_PERFOMANCE_TARGET_BECHMARK < 0
THEN ACTUAL_PERFOMANCE_TARGET_BECHMARK * 300
ELSE 0
END
END

Use Nested iif, or Switch

iif(Fields!ActualPerformanceMinBenchmark.Value > 0, Fields!ActualPerformanceMinBenchmark.Value*500,iif(Fields!ActualPerformanceTargetBenchmark.Value<0,Fields!ActualPerformanceTargetBenchmark.Value*300,0))

Edit:Switch Example

Switch(Fields!ActualPerformanceMinBenchmark.Value>500,Fields!ActualPerformanceMinBenchmark.Value*500,Fields!ActualPerformanceTargetBenchmark.Value<0,Fields!ActualPerformanceTargetBenchmark.Value*300,0)

komal145 SSCrazy Eights Points: 9918 More actions · Answer 2

Thank you ray.IIf worked for me but switch is not working.