format matrix cells based on value

• mark.hurter

  Valued Member

  Points: 52

  More actions

  August 19, 2008 at 12:12 pm

  #191456

  hello, I have a matrix in which the values are populated by the matrix. The values are mixed together and need to be formatted based on their values. basically, if something is more than 100, it will be money. If it is less than 100, just a regular number. Here is the iif statement that I have constructed, but I get an error saying it cannot refer to itself. How woudl I work around this. TIA

  =Iif(InScope(me.value > 100),FormatCurrency(SUM(Fields!VAL.Value)), SUM(Fields!VAL.Value))

• mark.hurter

  Valued Member

  Points: 52

  More actions

  August 19, 2008 at 1:24 pm

  #860238

  nevermind. Some more digging and testing gave me this.

  =Iif((SUM(Fields!VAL.Value) > 100), FormatCurrency(SUM(Fields!VAL.Value)), SUM(Fields!VAL.Value))