![]() ![]() I usually just look at the first three or so digits and the last three or so, mumble them to myself, switch to the other column and mumble those to myself. Aside from comparing row counts, this is about as simple as it gets. One quick trick you’ve probably used is to grab an entire column of output and check its SUM in the status bar. In other words, don’t do these tests on the only copy of your output! The Most Basic of Tricks – Comparing Sums Please note these examples all assume the data you’re comparing is easily re-creatable, e.g., it comes from a data connection or was exported from another tool. I’ll show some tricks I use to do these comparisons. A lot of times this means comparing a report to its previous published version and confirming that the outputs are identical before moving on with the process. I’m going to talk about a fairly pedestrian topic, but one I deal with daily as a data analyst and report writer: comparing versions of output data.Īt my work we have a report modification and publication process to verify that they’re outputting reasonable results. Look at all those posts! Hey, is that an Office XP beer stein… where’d you get that? Gosh, do you really wear all these baseball caps? Wow, it’s even nicer in here than I imagined. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |