Topics Map > University of Chicago > IT Services > Business Systems > Reporting Systems
Business Objects - Webi - How-to Advanced - Creating a Prompt that Doesn't Affect the Query and is Usable in Reports
This article explains how to create a prompt that doesn't affect the query that you can use in formulas in your report.
Add a pair of conditions for a single field (not already in the conditions) to your query
Where one is for "equal to" and the other for "not equal to".
Set both conditions to the same prompt value a
Nest them with an or
This creates a pair of conditions that have no impact on the data returned; the field will always be equal to or not equal to any prompt value you enter. You can now use the prompt in formulas, reformatting it to a date (use the todate() function) or number (use the tonumber() function) if needed.