tekst selection in If statement

[#1]

Hello,

I want to display a table with certain order numbers in it.

I would like to do this using de If function.

Are made up through the following format :

IPMOR11-0778

IPMRC10-0004

IPMOF10-0001

I would like the table only to show the order containing IPMOR.

Can anybody help me with this ?

Thanks

[#2]

Hello,

I suppose you want to use a calculated dimension. Lets call the field "Account Name" and create the dim like this:

=if( Left([Account Name],5) = 'IPMOR', [Account Name])

Regards,

Roland

[its_anandrjs]

Hi,

Try the below code

=If( Match([Account Name],Left([Account Name],5) = 'IPMOR')  , [Account Name] )

To check  IPMOR only in the expression or table.

Rgds
Anand