topic Re: Format string percentage in Template Report in Reporting Service & Alerting

Format string percentage in Template Report

jeanful — Fri, 19 Dec 2025 13:14:01 GMT

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!

Re: Format string percentage in Template Report

ysalvi43 — Wed, 11 Mar 2026 06:42:47 GMT

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

Re: Format string percentage in Template Report

WeLoveQlik — Wed, 11 Mar 2026 12:38:50 GMT

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

Re: Format string percentage in Template Report

ysalvi43 — Wed, 11 Mar 2026 13:38:38 GMT

Hello

You can use alt function

Thanks