User Defined Format Numbers in Report Table

[smoothdurban]

Hello All

I have a report template which displays a numerical channel of numbers.

Normally I format the column in the table to display only 2 decimal places.

This usually suffices however there are instances were I have a very small negative number (For example -0.00004624) and when I format the column display to 2 decimal places (d.dd) I get -0.00 which confuses some of my clients.

Is there a way to use the user defined category to round the entire channel which would eliminate the -0.00 condition.

In addition please keep in mind that the data in the portal that the table column object references cannot be altered nor do I want to create any additional copies of the original data.

Thanks

[gsklyr]

If you are expecting no negative values, you can use "abs d.dd"

And here is the reference

http://zone.ni.com/reference/en-XX/help/370858P-01/genpresent/genpresent/genreport_format/

[smoothdurban]

This will have to suffice for the time being.

Thanks