COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: dlomartra on 20 Feb 2018 03:16:23 PM

Title: Refer to a Page Set in an Expression
Post by: dlomartra on 20 Feb 2018 03:16:23 PM
Hello,

I want a calculation to vary depending upon which iteration in a page set it is on. How do I call the page set value in an expression.

IE. if I had a page set that iterates through members 1,2,3 how could I write and IF statement like this:

IF
(PageSet = 1)
THEN
Calculation1
ELSE
Calculation2

Thanks in advance!
Title: Re: Refer to a Page Set in an Expression
Post by: hespora on 21 Feb 2018 02:47:45 AM
You don't do that. A page set is driven by a data item in your query, so you just reference that data item.