I'm validating reports that I've migrated to Management Reporter and I've come across a weird problem that I can't figure out.
I have a report that pulls data from an Excel worksheet - some rows use the Excel data, while other rows use G/L data. There are 12 columns - one for each month of the year.
On the rows that pull data from the Excel worksheet, the data is doubled up; the rows using G/L data are correct. For example, I have a cell that, according to the Excel worksheet, should have $10,000 in it, but the Management Reporter report has $20,000 in it.
I've defined the row like so: @WKS(B=B2, C=C2,.....M=M2) where B=January, C=February, and so on.
Very odd!
I have other MR reports that use Excel worksheets OK, but I think this is the first one I've looked at that simply pulls the data from specific columns - all my others use the /CPO option to move across the worksheet, depending on which month it is.
