Calculated Dimension

[evansabres]

I am attempting to create a calculated dimension.

I want my field to display the 'PriceLevel' when it is not equal to the following:

'100 Preferred Rinkside'

'100 Level II Rinkside'

'100 Level III Rinkside'

'Hockey Suite'

I attempted

=if(PriceLevel <> '100 Preferred Rinkside' or PriceLevel <> '100 Level II Rinkside' or PriceLevel <> '100 Level III Rinkside' or PriceLevel <> 'Hockey Suite', PriceLevel)

However, this seems to only remove the '100 Preferred Rinkside'

Am I structuring this incorrectly?

[its_anandrjs · Accepted solution]

Then write

=If( NOT Match( PriceLevel ,'100 Preferred Rinkside','100 Level II Rinkside','100 Level III Rinkside','Hockey Suite') PriceLevel)

[evansabres]

Thanks!