calculated dimension help

[arusanah]

Hello ,

trying to remove Data in Dimension that starts with "New".

if( not match(County,'New*'),county)

if(county='New*','NULL',county)

tried above expressions but not working , pls help

[sunny_talwar · Accepted solution]

Try this with WildMatch instead of Match

If(Not WildMatch(County, 'New*'), County)

[sunny_talwar]

or

If(County NOT LIKE 'New*', County)