Multiple formats for the same cell?

• mmiller 85218

  SSC Enthusiast

  Points: 141

  More actions

  February 7, 2013 at 1:59 pm

  #268291

  I am wondering if this is even possible....

  I have a parameter that lets the user select various options, all starting with either 'Count' or 'Amount'

  This then feeds into a matrix with Program as the row and Date as the column with the paramter metric they selected in the table.

  I want to format the cell to either currency if they select an 'amount' parameter or numerical if they select 'Count'

  Is this possible and if so, how would I go about doing it?

• mmiller 85218

  SSC Enthusiast

  Points: 141

  More actions

  February 7, 2013 at 3:23 pm

  #1585684

  I figured it out, and it was much easier than I thought 🙂

  =iif(left(Parameters!Search.Value,6) = "Amount","'$'#,0","#,0")