LEFT WITH TRIM AND IF STATEMENT

[Uri]

Hi!

I have 2 fields: price and phn_num.

In phn_num field I want to display following:

If price is 0 then I want last three digits of phn_num to be replaced with XXX. 

BR,

Artur

[QFabian · Accepted solution]

Hi @Uri !, please try this :

if(price=0, mid(phn_num,1, len(phn_num)-3) & 'XXX', phn_num)

[Uri]

Hi @QFabian !

It works as expected! 

Thank you!

BR,

Artur