Format string percentage in Template Report

[jeanful]

Hi,

I have a template report which exposes data with a table. It receives some null values. I'd like to show nothing (blank) in case the number is null. I set this format string in the template report, but id shows always 0% where there is a null: {0:0.##%}

How can I achieve this?

Thanks!

[ysalvi43]

Hello
Is it nprinting report? if yes you can format the null values to 0% and if it not please clarify the report type

Thanks 

[WeLoveQlik]

Can you fill in the nulls with 0 in the script, therefore eliminating the nulls in the report?

[ysalvi43]

Hello 

You can use alt function 

Thanks