Expression =if( [company_ar]|=[CASH SALES],[company_ar]) not working ?

[paulyeo11]

Hi All

I have a Table 1.

The dimension field =

=company_ar

I dont want it to display CASH SALES  :-

I use below expression :-

=if( [company_ar]|=[CASH SALES],[company_ar])

it does not work. Can some one advise me ?

Paul

[paulyeo11]

Mt QVF

[brunobertels · Accepted solution]

Hi

Try this expression

=if( [company_ar]<>'CASH SALES',[company_ar])

[paulyeo11]

Thank you sir

[paulyeo11]

Hi All

=if( [company_ar]<>'CASH SALES',[company_ar])

Above expression working fine , Now i like add one more condition 'EXPORT SALES'

I try below expression it does not work.

=if( [company_ar]<>'CASH SALES' or 'EXPORT SALES',[company_ar])

=if( [company_ar]<>'CASH SALES' and 'EXPORT SALES',[company_ar])

Can some one help me,

Paul Yeo

[brunobertels]

Hi

Try this

=if( [company_ar]<>'CASH SALES' or [company_ar]<> 'EXPORT SALES',[company_ar])

if( [company_ar]<>'CASH SALES' and  [company_ar]<>'EXPORT SALES',[company_ar])

[paulyeo11]

Hi Bruno

it work fine , thank you.

if( [company_ar]<>'CASH SALE' and  [company_ar]<>'EXPORT SALES',[company_ar])

Paul