NPrinting Rounding Not Working as Expected

SuzanneD — Mon, 10 Dec 2018 20:49:36 GMT

I'm using Qlik NPrinting 17.3. I added a table that is supposed to round to 2 decimals.

The expression is as follows:

round(avg(aggr(Distinct avg({<PrimaryDiagnosisFlag ={'1'}>}LengthOfStayDaysNBR),FacilityAccountID)),0.01)

It is rounding in QlikView.However, it is not rounding as expected in NPrinting. I've tried both "Keep Source Formats" checked and unchecked.

Any suggestions on a fix or workaround?

Re: NPrinting Rounding Not Working as Expected

Lech_Miszkiewicz — Mon, 10 Dec 2018 21:20:14 GMT

Hi,

I am not sure if i understand your question properly. Do you wanted to round values to 2 decimal points? or did you wanted to format values , so only 2 decimal point are visible.

The expression you have is a Qlik expression and it works the same in Qlik as in NPrinitng. The version of NPrinting you are using is extremly old - I strongly suggest to upgrade. This might also exclude some bugs which now i dont even remember.

Maybe share little bit more about what you are trying to do and provide:

the info and screenshot of your source data Qlik Table (you can scramble it) as long as we can identify how the values are shown, what are the settings on Properties->Number section
the screenshot of your NPrinitng template
screenshot of your results from NPrinitng
screenshot of how you would expect results to look like.

Above mnetioned information will help us understand where you might have a problem and how to solve it.

regards

Lech

topic Re: NPrinting Rounding Not Working as Expected in Qlik NPrinting

NPrinting Rounding Not Working as Expected

Re: NPrinting Rounding Not Working as Expected