6 Replies Latest reply: May 23, 2018 8:42 PM by Yeo Poh sai RSS

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

    Yeo Poh sai

      Hi All


      I have a Table 1.


      The dimension field =




      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 ?