Expression with parameter

• HigD

  Valued Member

  Points: 74

  More actions

  January 26, 2016 at 7:00 am

  #315318

  Hi,

  I'm trying to do something really simple but not quite getting it right. I have 5 text boxes:

  Q1, Q2, Q3, Q4 and Full Year

  I want the text box to highlight when selected. This is easy enough when I select one at a time:

  =IIF(Parameters!quarter.Value.=1,"DarkSlateBlue","White")

  What do I need to add for the Full Year box to highlight? I want the expression to say something like, when all values are selected in the parameter, then highlight blue, but I'm not exactly sure of the syntax.

  Cheers

• HigD

  Valued Member

  Points: 74

  More actions

  January 27, 2016 at 2:48 am

  #1854628

  If anyone was interested I solved this by doing the following:

  =IIF(Parameters!quarter.Count=4,"DarkSlateBlue","White")