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

Rank and after aggregation for a render variable

Started by Juneytunes, 10 Jan 2011 04:00:06 PM

Previous topic - Next topic

Juneytunes

I want to use one query for 5 lists and have the render variable use a 2 part statement to select the data to display. I can get this to work with 5 queries that are all the same except for the filters. The denomination filter changes each list. The rank filter is After Aggregation so that it is ranking the new denomination. The problem with the render variable is that I can't figure out how to get it to work after aggregation with 2 statements in 1 boolean.
I am using the filters: Denomination =0.01 (before aggregation) and Rank <11 (after aggregation).
I am using report studio and version 8.4 with Neteeza.
Is there a way to write:
(Denomination = 0.01) and (Rank < 11, postfilter) as one boolean variable?