5 Replies Latest reply: Jan 9, 2013 5:55 AM by DanieleC RSS

    Error in Expression for Text Colour

    Helen Pippard

      Hello

       

      I was wondering if you could kindly help me

       

      I have written an expression for text colour in table and am getting a syntex error:

       

       

      =

      if (Level3_Month='95TH CENTILE',time(Fractile({<Inline_Monthly_DataSource={ 'ED'} >} Inline_Monthly_Data_A,0.95>240), RGB(255, 0,0), Green

      ())

      )

       

      The error is in this part of the expression, where the comma is

      RGB(255, 0,0), Green ())

       

      Can anyone suggest changes to the script?

       

      Many Thanks

      Helen