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

Use Variable in Expression?

Started by bloopaman, 16 Aug 2013 06:09:23 PM

Previous topic - Next topic

bloopaman

I have 2 pages.  I want to have the same table on each page, but on the second page, I want to divide by a certain value.  I've tried setting a variable via the PageName function, but I have no idea how to use the variable in the expression so I can:  [Column] / ?Variable? 

Report is due tomorrow god/forum please help me!

MFGF

Hi,

Couldn't you just go to Page Explorer and add a second report page in there? Once you have your second page, you can put whatever you like onto it, with it's own specific logic.

Cheers!

MF.
Meep!

Lynn

I think you are confusing layout and query operations. You can't use variables or layout functions in query expressions.

You will two separate containers each referencing the appropriate query containing the desired logic. They could use the same query if the query has both calculations such as one query item withe the expression [Column] / [Page 1 Divisor] and then another query time with the expression [Column] / [Page 2 Divisor].

Then use the first query item on the layout container in page 1 and the other on page 2.