Remove brackets and quotation marks with GetFieldSelect

[DWolsie]

Hello everyone,

I've got a problem that I haven't found a solution to yet. I've got a KPI field where I use the GetFieldSelections like this:

 = 'Aufteilung Budget ' & GetFieldSelections([GJAHR], ', ')

 However, whenever I load the Sheet and 2024 is pre-selected, it looks like this:

It is only when I deselect and the reselect the GJAHR that it looks correct:

Is there a simple or elegant solution to this problem? Thanks in Advance!

[DWolsie]

Hello everyone,

I've got a problem that I haven't found a solution to yet. I've got a KPI field where I use the GetFieldSelections like this:

 = 'Aufteilung Budget ' & GetFieldSelections([GJAHR], ', ')

 However, whenever I load the Sheet and 2024 is pre-selected, it looks like this:

It is only when I deselect and the reselect the GJAHR that it looks correct:

Is there a simple or elegant solution to this problem? Thanks in Advance!

[sbaro_bd · Accepted solution]

Hi @DWolsie ,

Indeed, it's very strange! Use the PurgeChar expression to fix it : 

='Aufteilung Budget ' & PurgeChar(GetFieldSelections([GJAHR], ', '),'()"')

Regards.

[seanbruton]

Kudos nice simple solution!!