Replacing text

• krypto69

  SSChampion

  Points: 13609

  More actions

  October 17, 2013 at 1:59 pm

  #395684

  Hi,

  I am bringing into my matrix a field called 'Acct' (account).

  The expression is:

  =Fields!Acct.Value

  I would like to keep bringing in this value but every time acct is 5200 I want it to say 'Regular Hours' instead of '5200'

  and 'Overtime Hours' every time it is '5204'

  How do I do that?

• lynns

  Say Hey Kid

  Points: 695

  More actions

  October 17, 2013 at 2:43 pm

  #1659495

  I am assuming the Acct field is an integer here.

  = IIF(Fields!Acct.Value = 5200,"Regular Hours",IIF(Fields!Acct.Value = 5204,"Overtime Hours","Whatever you want if it isn't either"))