2 Replies Latest reply: Jan 18, 2013 10:51 AM by sree anaarasi 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!