How do I format a cell value in Rich Text object

[mikecrengland]

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?

Thanks!

Mike

[Ruggero_Piccoli]

Hi,

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

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.

[mikecrengland]

Thanks, Ruggero,

Does that only work if the cell is on it's own? If it needs to be part of a paragraph, can it still be formatted?

Thanks!

mike

[Ruggero_Piccoli · Accepted solution]

Hi Mike,

It is a property of the cell, so I think it will works everywhere you place the cell.

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.