Formula Filter

[gatorfe]

I have the following formula set up as a data item on a query that is on the prompt page of a report:
right([AccountNumber],3)Ã, 

I have lots of accounts that end in 040 and I do not want to see those.Ã,  I added a filter to the query:
[Dept] <> 040

When I do this the report does not run.Ã,  Is there any other way to tell the report that I do not want to see account numbers with 040 in the drop down of my prompt page?Ã,  Thanks in advance for any suggestions.

[MDXpressor]

Are you serving the Prompt Page dropdown with an independant query specific to the selections?  Perhaps you have just served it with the data item you use to also serve the data container (the list, crosstab or chart) you are attempting to render?

[bdybldr]

gatorfe,

I assume you're using substring or right function in your filter because you said departments end in 040.  The filter will never work unless department is only 3 characters long.