3 Replies Latest reply: Aug 15, 2017 3:33 AM by Mohammed Mukram RSS

    How to Assign color in Text Object for up Arrow and Down Arrow

    Ravi Kishore

      This is My Expression:

       

      =' MTD: Overall WW ADM & ITOM License sales were ' & Num($(v$MaxYearTotalOrdersMTD),'##.#') & 'M ' & 'compared with ' & Num($(v$Prev1YearTotalOrdersMTD),'##.#') & 'M ' & 'last year ' & If($(v$MaxYearTotalOrdersMTD)-$(v$Prev1YearTotalOrdersMTD)<=0,chr(9660),chr(9650)) & num(($(v$MaxYearTotalOrdersMTD)-$(v$Prev1YearTotalOrdersMTD))/Fabs($(v$Prev1YearTotalOrdersMTD)),'#.#%')

       

      I need chr(9660),chr(9650)) to be made Red and Green.

       

       

      Text.JPG

       

      Please can you help me out.

       

      Thanks,

      Ravi