Print Page - more on running-total()

Title: more on running-total()
Post by: axxo on 02 Apr 2009 05:57:35 PM

I am having trouble doing a running total of the following data item called [Total]

[Total] has expression
total( [measure] within set set([row_item])) +[Journal]

An ideas??

Title: Re: more on running-total()
Post by: CognosPaul on 05 Apr 2009 07:00:46 AM

I've never had luck using running functions with olap.

Try this instead:

total([Sales]
within set periodsToDate (
[Cube].[Dates].[Years].[All],
currentMember ([Cube].[Dates].[Years])
))

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: axxo on 02 Apr 2009 05:57:35 PM