2 Replies Latest reply: Feb 27, 2018 3:13 AM by Yeo Poh sai RSS

    Set expression how can 1 exclude 2 condition ?

    Yeo Poh sai

      HI All


      Below expression work fine :-

      Sum({<year={">=2015"},sub_seg={"02"}>} sales)


      I want to modify the above expression with exclude seg=02 , it work fine :-

      Sum({<year={">=2015"},sub_seg|={"02"}>} sales)


      Now i encounter problem , when i try exclude one more seg=01 :-

      Sum({<year={">=2015"},sub_seg|={"02"},sub_seg|={"01"}>} sales)


      Can some one advise me where go wrong ?


      Paul Yeo