Duplicate footer in list

[willg]

Hi everyone,

I'm currently getting a very strange issue where the footer for a list I'm using to keep grouped subtotals is getting duplicated, however the values are not getting duplicated.
A screenshot of what is happening is below, I find this very strange as I have set this list up the same as any other list, yet this ne is returning the duplicate row.



If anyone could shed some light on why cognos is doing this it would be really helpful, it's very frustrating currently.

[CognosPaul]

Can you run the query in tabular mode? Is it possible that there are null values being returned for the first 3 columns?

[willg]

Yes there may be one row that's been joined & has some null columns. I found out that changing the cardinality of the join can remove the duplicate row, but then also removes some of the data I want to return  :-\

[CognosPaul]

how about doing a filter in the query to remove that row?

[willg]

That row was actually one I required for some of my sums, so I couldn't really filter it out. I have a (temporary) solution at the moment where I've split it into 2 seperate queries & lists at the moment, but not ideal