COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: cognovice on 13 May 2021 01:14:46 AM

Title: <Total(PMTD GP%)> cell is wrong when the list report is exported to excel 2007
Post by: cognovice on 13 May 2021 01:14:46 AM
Hi All,
Please find attached screen shot of the List Headers & Footers and Report Design.

The problem with this report is the <Total(PMTD GP%)> highlighted in yellow.  When the report is run in html, this gives correct GP% calculation but when the same information is exported to excel, it copies the overall <Total(PMTD GP%)> from "Total" row and pastes to all other total rows including "Branch" rows.

Your assistance will be of immense help.

Thank you,

Kind Regards,
R
Title: Re: <Total(PMTD GP%)> cell is wrong when the list report is exported to excel 2007
Post by: cognovice on 13 May 2021 05:41:07 PM
Sorry, I am unable to attach the word document as I am getting an error message which says, "An Error Has Occurred!"  "Cannot access attachments upload path!
Title: Re: <Total(PMTD GP%)> cell is wrong when the list report is exported to excel 2007
Post by: cognovice on 13 May 2021 07:19:00 PM
Hi All,
Can anybody assist me here please...


Kind Regards,
R