COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: barrysaab on 14 Feb 2012 04:50:40 AM

Title: Report Expression
Post by: barrysaab on 14 Feb 2012 04:50:40 AM
How best can interpret this.Could someone explain in easy way.

running-difference ( numeric_expr [ at exp {, expr }
] [ <for-option> ] [ prefilter ] )
running-difference ( [ distinct ] numeric_expr [ <for-option>
] [ prefilter ] )
<for-option> ::= for expr {, expr } | for report | auto

Thanks
Title: Re: Report Expression
Post by: HalfBloodPrince on 14 Feb 2012 05:16:49 AM
Returns a running difference by row, calculated as the difference between the value for the current row and the preceding row, (including the current row) for a set of values. The "<for-option>" defines the scope of the function. The "at" option defines the level of aggregation and can be used only in the context of relational datasources.


Example: running-difference ( Qty )
Result: For each row, returns the quantity and a running difference between the value for the current row and the preceding row.
::)
also check this Document
http://www.itap.purdue.edu/ea/files/UnderstandingTheCognosSummaryFunctions.pdf
Title: Re: Report Expression
Post by: barrysaab on 14 Feb 2012 05:29:44 AM
Thanks HalfBloodPrince.I am confused with all these braces{,[,( ) all i know is {} is optional.Thanks alot again.
Title: Re: Report Expression
Post by: bladeless on 10 Jul 2015 03:24:30 PM
Could anyone tell me where I can get this pdf?