Filter on IF condition

[Uri]

Hi!

I have 2 fields: price and fakttext.

I want 4 last digits to be replaced with XXXX in case price is = 0. Today I'm using this:

if(price =0, mid(fakttext,1, len(fakttext)-4) & 'XXXX', fakttext) and it works good.

But now I don't want to apply my condition for some specific values.

IF price = 0 THEN XXXX BUT NOT FOR  'Japan',  'Sweden' etc.

BR,

Artur

[MayilVahanan · Accepted solution]

Hi @Uri 

Try like below

If(Price = 0 and not wildmatch(Country, 'Japan', 'Sweden'), left(fakttext, len(fakttext)-4)&'XXXX', fakttext)

[Uri]

Hi @MayilVahanan,

it works! Thank you.

BR,

Artur