Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try this.
Sum({<year={">=2015"},sub_seg-={"02","01"}>} sales)
Regards,
Kaushik Solanki
Try this.
Sum({<year={">=2015"},sub_seg-={"02","01"}>} sales)
Regards,
Kaushik Solanki
Hi Kaushik
Thank you very much. it work
Paul