Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
Can any one please help me on below requirement.
I have one dimension called STATUS like below.
In this dimension I have to show all the records other than Draft and Failed like status -={'Draft','Failed'}.
Please help me on this.
Thanks in advance.
Hi,
try this:
=Aggr(Only({<STATUS-={'Draft','Failed'}.>}STATUS),STATUS)
or
=if(not match(STATUS,'Draft','Failed'), STATUS)
Hi,
try this:
=Aggr(Only({<STATUS-={'Draft','Failed'}.>}STATUS),STATUS)
or
=if(not match(STATUS,'Draft','Failed'), STATUS)