COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: mlinsenbardt on 13 Oct 2011 08:51:14 AM

Title: Create Variance in List or Crosstab using the data from a Package
Post by: mlinsenbardt on 13 Oct 2011 08:51:14 AM
Good Thursday,

Will anyone share their knowledge on how to create a variance column in a List or Crosstab using the data from a Package?

Extended thanks!

Prior  Current  Variance
9              10          1
10               9        (1)
Title: Re: Create Variance in List or Crosstab using the data from a Package
Post by: eta05380 on 11 Jan 2012 03:04:34 PM
Create a new data item in the query in Report Studio.

Data item expression:
([Current] - [Prior])

Set Data Item Aggregration to Total