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!
You're looking for a token prompt:
#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.