Hi All,
I have downloaded the reports from WAD to excel, Here I am facing a peculiar problem like
the Fiscal week for the expended row shows 00.00.0000 and has 'X" prefexing the row but beneath the expended row other records shows correctly.
For eg
the Fiscal week shows weeks show as 001.2005 and but in the spreadsheet it shows as 00.00.0000 and therefore doesnt indicate the week number.
Fiscal week Fiscal Period
00.00.0000 01 2005
01.01.2005
01.01.2005
02.01.2005
02.01.2005
00.00.0000 02.2005
01.02.2005
01.02.2005
05.02.2005
05.02.2005
Also the records in the excel sheet has duplicate entries
Any help will be appreciated.