Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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],