I have two tables of calculations that are generated in slightly different ways. Ideally, the numbers should be the same. But in the case that they are not, I am providing the users with an error report showing which columns are divergent, and by how much.
I haven't seen any examples of this type of reporting before, and my idea is to present the errors in some kind of table, with sets of three rows, as seen here, highlighting the columns that are in error:
The sets of three rows could be repeating depending on how many locations we are reporting on.
My question is this: is this good practice for conveying this type of information? Are there any visual queues I could use besides highlighting the values? And is the "Difference" row necessary, or could I possibly use a tooltip or other element?
The goal is to have a Material-style report, not necessarily a table, but one that would convey the appropriate information in a way that is clear.