topic Re: NPrinting Issues in Pixel Perfect - Summarizing Percentages / Currency Formatting in Qlik NPrinting

NPrinting Issues in Pixel Perfect - Summarizing Percentages / Currency Formatting

lgtsotrsdh — Wed, 01 Feb 2017 14:01:18 GMT

Hi,

I'm building a couple of NPrinting reports in Pixel Perfect, and I need to do a summary of a percentage field. The summary options like Sum, Average, Percentage, etc. don't seem to work. I see there's a Custom selection, but that doesn't seem to do anything. I tried creating a calculated field to recreate the percentages, but the summary options don't seem to work with that either. Am I missing something?

Also, in the same report I'm having issues where Currency type fields are showing just a dollar sign instead of $0. I have it setup to use 0 in place of null. I can't seem to find any other formatting options to add the zero.

Any help would be appreciated.

Thanks,

Scott

Re: NPrinting Issues in Pixel Perfect - Summarizing Percentages / Currency Formatting

jmmolero — Thu, 10 Jan 2019 12:40:29 GMT

Hi!,

This post is old but I have the same problem with the percentages.

Somebody can help me?

thank you.

Re: NPrinting Issues in Pixel Perfect - Summarizing Percentages / Currency Formatting

kdmarkee — Tue, 28 Apr 2020 17:01:24 GMT

I'm not sure if this will help but when I build pixel perfect reports, I use a lot of levels. With that said, if under my Levels node I have a chart object listed, and I use that chart object for the Data Member of my detail band, I had to use my % field from the chart object under the Levels node and not from the Tables load (where I also have that same chart object loaded). I was able to use my % field in my detail band and use Avg of my % field in a summary/totals band. Not sure about nulls and zeros formatting however, I too see what appears to be inconsistent results.