Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Hi @DWolsie ,
Indeed, it's very strange! Use the PurgeChar expression to fix it :
='Aufteilung Budget ' & PurgeChar(GetFieldSelections([GJAHR], ', '),'()"')
Regards.
Hi @DWolsie ,
Indeed, it's very strange! Use the PurgeChar expression to fix it :
='Aufteilung Budget ' & PurgeChar(GetFieldSelections([GJAHR], ', '),'()"')
Regards.
Kudos nice simple solution!!