3 Replies Latest reply: Sep 14, 2017 8:58 AM by Ruggero Piccoli RSS

    How do I format a cell value in Rich Text object

    Michael Reagan

      Hello All -

       

      In NPrinting 16 using Pixel Perfect report, I'm trying to create a Rich Text object with a  few different cells in the text. My tables have the values formatted as ##.##%, but they come through as a float. How do I format those cell values?

       

      2017-09-13_12-21-26.png

       

      Thanks!

       

      Mike

        • Re: How do I format a cell value in Rich Text object
          Ruggero Piccoli

          Hi,

           

          Open the cell smartag (the small arrow in the upper right corner) and set the Format String.

          FormatString.png

           

           

          Best Regards,

          Ruggero

          ---------------------------------------------

          When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.