Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Community
Please find the attached and advice where i can put the not equal to operator .
Thanks
Sureshqv is Ryt. In set analysis <> not work. Instead -= means not equal or exclude
for example
Sum({$<[Delivery status] -= {"Not delivered"}>}[Sales Amount])/ Sum([Sales Amount])