2 Replies Latest reply: Jan 18, 2013 10:51 AM by Sree Anarasi RSS

    If statement

      Hi -


      I am working with a table where i need to format in Bold specific rows. I am trying to achieve this using if statement within the 'Text Format' properties.


      if(Consolidated='Revenue','<b>',if(Consolidated='Cost of Goods Sold','<b>',if(Consolidated='Taxes','<b>', ' ' )))


      For some reason this expression only highlights first row 'Revenue' and does not work the rest of the rest of the fields.



      What am I doing wrong?


      Please help


      Thank you!