topic Re: Number formatting in nPrinting in Qlik NPrinting

Number formatting in nPrinting

vireshkolagimat — Tue, 02 Aug 2016 14:35:11 GMT

Hi Guys,

I am using the below expression to format the numbers to one decimal place but i am not getting the result.

I have a report which is added as Level in nPrinting.

=NUM(IF(Desc=value,Column,''),'#.0;(#.0)')

Regards,

Viresh

Re: Number formatting in nPrinting

agni_gold — Wed, 03 Aug 2016 05:39:20 GMT

Can you please try

#,##0.0

Thanks

Agnivesh

Re: Number formatting in nPrinting

vireshkolagimat — Wed, 03 Aug 2016 11:35:37 GMT

Not working. If i use the modified version of the above expression (If(Desc=value, Column, '')), i get the numbers exactly but i need to show the negative numbers in brackets. I need some way to show the negative numbers in brackets like -8 as (8).

Re: Number formatting in nPrinting

Wed, 03 Aug 2016 12:19:10 GMT

Assuming this is an Excel report

Deselect "Keep source format" in the chart properties
Set the Field Format to #,##0.00
Set the column format in Excel to the desired format; I think "Accounting" will give you negatives in brackets.

This should give you the desired result.

Best

Aran

Re: Number formatting in nPrinting

vireshkolagimat — Wed, 03 Aug 2016 14:45:25 GMT

I got the solution. I need to use the num function within the if function.

Like if(Desc=value,num(Column,'#.0;(#.0)')