topic Re: Filter on IF condition in App Development

Filter on IF condition

Uri — Sat, 16 Nov 2024 01:04:29 GMT

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 — Sat, 21 Nov 2020 03:58:09 GMT

Try like below

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

Uri — Sun, 22 Nov 2020 20:31:19 GMT

it works! Thank you.

BR,

Artur