Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

RSUM?

Status
Not open for further replies.

dmi4587

MIS
Nov 15, 2011
1
DE
Hello all!
I have a small problem with RSUM in Cognos and get always an error with this function.

Here is the following statement:
RSUM(1 FOR DFORDERUNGENGLIEDERUNG.JAHR, DFORDERUNGENGLIEDERUNG.PERIODE, DFORDERUNGENGLIEDERUNG.G1, DFORDERUNGENGLIEDERUNG.G2, DFORDERUNGENGLIEDERUNG.G3 ORDER BY DFORDERUNGENGLIEDERUNG.JAHR ASC, DFORDERUNGENGLIEDERUNG.PERIODE ASC, DFORDERUNGENGLIEDERUNG.G1 ASC, DFORDERUNGENGLIEDERUNG.G2 ASC, DFORDERUNGENGLIEDERUNG.G3 ASC LOCAL) AS SC5

Can anybody tell me, what RSUM does in this statement and why it doesn't work in my Cognos 10 Framework Manager?
Its funny but the function works in an older version of Cognos.

Are there any other opportunities to replace this function with another one?

Thank you in advance!
 
RSUM is the Cognos 7 expression for running sum. In Cognos 8 and higher the equivalent function would be : running-total

Ties Blom

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top