In SSRS 2008, How do I build an expression in a Matrix-Tablix, Fill section?

This is what I have so far.
=Switch(col A <0, "Orange", col B = 0,  "Red")

In a Matrix Tablix Fill  I need the full expression to:

(If col A is < 0 then row is orange
If col B = 0 then row is  red
If neither above apply then row is  transparent
If both apply Col B then row is red)
rhservanAsked:
Who is Participating?
 
devlab2012Connect With a Mentor Commented:
use it like this:

switch (co A >= 0 and col B <> 0, "transparent",
col A < 0 and col B = 0, "red",
col A < 0, "orange",
col B = 0, "red")
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.