Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
How do i exclude Nulls from my Calculated Dimension Expression?
Below is my Code:
=if( aggr(rank(sum(People)),Service)<=vTopValue,Service)
SAMPLE TABLE:
Service | People |
---|---|
A | 200 |
B | 34 |
- | 676 |
- | 90 |
OUTPUT:
Service | People |
---|---|
A | 200 |
B | 34 |
Thanks in Advance.
Hi,
Rubeeeeeeeeeeeeeen you're a Star
This is what i want, then i suppressed the Null it still gives me what i want.
Thank you a lot.
Hi,
Thank you also your solution work Perfectly.
Thank you Guys.
Nice, glad to help.
Hi All.
Thank you all i got the answer and its working Properly
Hi,
In dimension , You can try this condition .
=if(Len(Service)>0, Service)
How about just using Service as dimension and using the expression:
sum({<Service={"=Rank(Sum(People))<=vTopValue"}>} People)