18
votes
6answers
325 views

When formatting numeric data with rounding, should the total line reflect the total of the rounded data, or the raw, unrounded data?

Consider this scenario: The rounded numbers add up to 195. But the rounded total would only be 193. So which total should you show when showing rounded numbers. The one that matches what is SHOWN ...
6
votes
5answers
994 views

Best way to represent null and empty data in an excel file

We have an application that allows users to design their own forms and export the data to excel. One problem is the representation of null or empty data. There are two scenarios that we need to ...
5
votes
1answer
138 views

Best formatting (aligment) for of a list of facts

In an application (though what follows applies equal well to a report) there will be a panel which shows a list of various statistics or facts, of this general form: "Category: data". So, for ...