Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi
i have a situation in which i am using an expression and in the expression i have to sum a measure based on two dimensions.
like sul({$<prodid={'a'},size shouldnt be equal to xl...........what is the sign to be used for not equal to???
Try using
sum({$<prodid={'a'},size -= {'x'}>} Measure)
i.e. using minus-equal.
Hope this helps,
Stefan
P.S:
IMHO, it helps to not think of an comparision operator (equal resp. not equal) when looking at '=' or '-=' set operator, but of set theory operators (set assignment / union, exclusion operators).