Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
=if(not match(MCO,'New *'),MCO)
trying to eliminate values in dimension that starts with "New". tried lot of expresions but not working .. pls help
Hi Archana,
In the definition of your calculated dimension you'll need to use an aggr function like this:
=aggr(if(not wildmatch(MCO,'New *'),MCO),MCO)
Cheers
Andrew
If you want to exclude where start the name new space any string. I have deleted the space from below expression.
This expression seems right to exclude the value or why not scripting
=if(not match(MCO,'New*'),MCO)
Hi Archana,
Try below script:
=if(not wildmatch(MCO,'New '),MCO)
Thanks.
try this
if(not match(MCO,'New'),MCO)
Match is for an exact match - you need WildMatch for a wildcard:
=If(Not(WildMatch(MCO, 'New*')), MCO)
try below
=If(Not(WildMatch(MCO, '*New*'))),MCO)
or
If(MCO NOT LIKE 'New*', MCO)
Hi Archana,
You can use the expression as Jonathan suggested.
=If(Not(WildMatch(MCO, 'New*')), MCO)
Hi Archana,
Try this,
=if(not(WildMatch(MCO,'New*')),MCO)
Hi Archana,
Try this: IF(LEFT(UPPER(TRIM(MCO)),3)<>'NEW',MCO)
Regards!