Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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