How to filter Accounts that ends with 000 in Dimensional Reporting

[cognos05]

What function can I use to filter Accounts that ends with "000".

Thanks,
Nithya

[BigChris]

right([AccountNumber],3) = '000'

I'm assuming the you're talking about a relational model and that the right function is available in your environment (you don't say if you're using SQL, Oracle etc.)

[MFGF]

What function can I use to filter Accounts that ends with "000".

Thanks,
Nithya

Still using a dimensional package?

if so, how about

filter([your Accounts level], caption([your Accounts level]) ends with '000')

MF.

[cognos05]

Thanks , Ends with works !!