Round numbers in reports
Posted on 2013-01-30
I have a report for lab results that I need to round numbers for. If a sample is positive for a virus for example and 4,452,000 are found, the number on the report should be >4,000,000. (Greater than 4 million) I also need to round down to thousands or hundreds if that is what the result is (ie: greater than one thousand) . Is there a function that will do this or will I need to write some code to test the number length and round down accordingly? Any number less than 100 can be left as is.