Combined Field Values Not Combining Properly

WiscoSippi — Mon, 20 Dec 2021 21:05:46 GMT

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],

topic Combined Field Values Not Combining Properly in App Development

Combined Field Values Not Combining Properly