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
Quote
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.
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