Conflicting HTML and Excel outputs

[Rajaggopal]

I was working on a small exercise in Cognos 8.2 and when i exported the HTML report to Excel 2002 the values were contradicting. Here are the screenshots of HTML and Excel outputs embedded in one file.

I have highlighted the conflicting values in the screenshot. The expression used in Final Column is below

running-total( [Expected Volume] ) + [Constant] - Total( [Expected Volume] )

The aggregate function of all the columns is set to "None" except for [Expected Volume] which has "Total".

I was just wondering where the error could be, in Cognos, in Excel or in my report.

[timbrelyp]

Hi, just tagging on here. My Excel results are changing my dates. All dates appear to be 1097 days after the correct date. (3 yrs and 1 day) I vaguely remember having this happen before but cannot remember the cause or solution.

In my case it is not a calculated value... just a date.
In CSV the date is correct, but in the format YYYY-MM-DD
HTML and PDF are correct and in the format  M/D/YY
In Excel Single Sheet the date is formated as MM/DD/YYYY and displayed as MM/DD/YY
I looked at the XML and the date as a number format is 1097 higher than the desired value.
Here is the style designating the format, but since the number is already wrong I am unsure what to do.
mso-number-format:"m\\\/d\\\/yy\;\@";


I'm using 8.4