While I have my 3 store managers ( and partners ) reviewing the Sales Analysis reports for various customers by - this reminds me of a much earlier bug reported to the help desk - that we await the speedy action of WHI ( ok - sorry for the sarcasm ---called in on April 13, 2010 and with NO ETA on if or when this bug will ever get fixed (call#1133029) - verified this today thru help desk).
The Sales Analysis report --when you export as DATA ONLY ( if you export as formated excel-there are merged cells that STO you from sorting data -- what good is that ) you will see an error in the data -- the excel image posted shows a pink line two rows down --that dat belongs to the RED area on line 7. So the report picked up an extra CR (carriage return) and two wrong LF ( line feeds)
In excel you can add a formula =A7 in the k4 cell. And you can drag this from K4 thru 4 to copy. Then you can drag down to copy formula to the bottom of the screen -- don;t worry -- we will sort and throw out the junk afterwards.
Then you COPY and PASTE SECIAL - just values into the area in red - columns K thru P
Now -- sort - I use column J - sort in ascending order and all your junk goes to the bottom and you can trash ...and you have a corrected data - again. Extra work courtesy of sloppy programing from WHI Nexpart
No comments:
Post a Comment