If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

more on running-total()

Started by axxo, 02 Apr 2009 05:57:35 PM

Previous topic - Next topic

axxo


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??


CognosPaul

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])
))