Dynamic lookup or dynamic expression evaluation in framework

[addicted2cognos]

Is there a way to evaluate an expression dynamically in a calculated query item?

For example if we pass an expression within a prompt to the Fw, it needs to evaluate it and populate the query item with result of the expression.

Any help will be greatly appreciated!

[CognosPaul]

You're looking for a token prompt:

Code Select Expand

#prompt('Expression','token','running-total([Sales])')#

That's an optional prompt that will default to running the expression running-total([Sales]) if nothing is entered.