Problem with Code filter

[Luke_Killer_IT]

Hello 

I have a problem with data filtering. I want text instead of blank fields in one column

It's My code if(Termine= null(),text('KaineAB'))

[Or]

Try using the isnull() function instead of = null().

[Luke_Killer_IT]

I used isnull () and it didn't help

[NitinK7]

use

if(Len(Termine)= 0,text('KaineAB'), Termine)

[MayilVahanan]

Hi @Luke_Killer_IT 

Try like below

if(Len(Trim(Termine))= 0,'KaineAB', Termine)

[Luke_Killer_IT]

I used your code but it still did not work, I will attach a screenshot, maybe it will be easier.

Only the red box is to have 'Kaine AB'.

[MayilVahanan · Accepted solution]

Hi, 

try like below

if(Isnum(Termine), Termine, 'KaineAB')

Or, send the sample file to verify