help with calculated dimension expression

[arusanah]

=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

[effinty2112 · Accepted solution]

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