02-28-2019 11:05 AM
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
02-28-2019 11:27 AM - edited 02-28-2019 11:31 AM
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/
03-06-2019 05:34 AM
This will have to suffice for the time being.
Thanks