Skip to main content
Announcements
Defect acknowledgement with Nprinting Engine May 2022 SR2, please READ HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
vireshkolagimat
Creator III
Creator III

Number formatting in nPrinting

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

1 Solution

Accepted Solutions
vireshkolagimat
Creator III
Creator III
Author

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

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

View solution in original post

4 Replies
agni_gold
Specialist III
Specialist III

Can you please try

#,##0.0

Thanks

Agnivesh

vireshkolagimat
Creator III
Creator III
Author

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).

Not applicable

Assuming this is an Excel report

  1. Deselect "Keep source format" in the chart properties
  2. Set the Field Format to #,##0.00
  3. 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

vireshkolagimat
Creator III
Creator III
Author

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

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