5 Replies Latest reply: Mar 27, 2012 8:44 AM by Anne Duffy RSS

    Text colour first character

      Hi Guys,

       

      I have a straight table that has a field called [Rejection Reasons], in some instances the results in this field are only ',' or a correct reason , but preceeded by a comma.

       

      I dont want to see the first comma in the chart,

       

      In the demension I have gone into [Text colour] and put in the following :

       

      if([Rejection Reasons]=',',RGB(255,255,255))

       

      That works for the ones that are only a comma, I then tried variations of to look for the ones that start with the comma , but they were changing all the text white ,

       

      if ( left ([Rejection Reasons],1)=',',RGB(255,255,255)))

       

      Can anyone help, I am looking to change comma text white when there in ONLY a comma OR when the statemnt starts with a comma

       

      Thanks a mill

       

      Anne