Combined Field Values Not Combining Properly

[WiscoSippi]

Hi!

This code generates the first bar chart which is almost perfect. I want to combine two of the values, 'SpecialOctave' and 'OverloadSoundTestAdder'. See below.

let vChrs = chr(32)&chr(160)&chr(10)&chr(13)&chr(9);
if(isnull([Sound Test_WESSOUNDTEST Description]),
	'None',
	purgechar([Sound Test_WESSOUNDTEST Description],'$(vChrs)')) as [WESSOUNDTEST_Consolidated],

 

Here's the code I wrote to combine the values and the result I'm getting which is NOT what I want. Any thoughts?  Source data is attached.

let vChrs = chr(32)&chr(160)&chr(10)&chr(13)&chr(9);
if(isnull([Sound Test_WESSOUNDTEST Description]),
	'None',
     if(match(purgechar([Sound Test_WESSOUNDTEST Description],'$(vChrs)'),'SpecialOctave','OverloadSoundTestAdder'),
     	'SpecialOctave_OverloadSoundTestAdder',
		sound_test_tmp
    )
    ) as [WESSOUNDTEST_Consolidated],