Ignore with multiple conditions

[psk180590]

Hello All,

From my below sample data i need to display only values which are not Total or have Rest in them.

ProductName

AA

AA1

AA3

AA6

RestAA

Total

BZ

BZ1

BZ5

RestBZ

Total

So, from the above fields in would need my output as below

AA1

AA3

AA6

BZ

BZ1

BZ5

I have tried writing as If(ProductName<>Total and left(ProductName,4)=Rest, ProductName). But, this gives me no values.

TIA!!

[Anonymous]

Try ProductName<>'Total' and 1-sign(WildMatch(ProductName,'*Rest*'))

[tresesco · Accepted solution]

Try placing single quotes properly like:

If(ProductName<>'Total' and left(ProductName,4)<>'Rest', ProductName)

[psk180590]

Missed the single quotes. Such small mistakes eat up lot time .

Thanks both for the quick help. Have a nice day a head!!