Percentages in N Printing

[paul_ripley]

Hello

I have a table in QV that uses the expression

num((Variance / [6 month average]) ,'##0%;(##0%);-')

This brings back the correct amounts

I then import it into N Printing

But the variances show as below.  Does N Printing not support percent formats when using a powerpoint template?

Can anyone sugest how to get round this

Thanks

Paul

[Ruggero_Piccoli]

Hi,

PowerPoint cannot change the format of a number so you have to export it as a formatted string just by changing the formula you posted.

Best Regards,

Ruggero

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

When applicable please mark the appropriate replies as CORRECT https://community.qlik.com/docs/DOC-14806. 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.

[paul_ripley]

Hi Ruggero

What is wrong with num((Variance / [6 month average]) ,'##0%;(##0%);-')

Does that not format the number as a percentage?  What change would I need to make?

Thanks

Paul

[lcontezini]

just check the box "keep source formats"

[Lech_Miszkiewicz]

Hi Paul,

num() function applies Qlik number formatting in Qlik on top of underlying numbers. It is not changing the actual value to string as it retains the details down to all decimal places etc...

The solution would be to apply "text" function on top of it to completly , although i hate that solution!

text(num((Variance / [6 month average]) ,'##0%;(##0%);-'))

cheers

Lech