How to Exclude Null Values from Calculated Expression?

[#1]

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.

[#2]

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.

[#3]

Hi,

Thank you also your solution work Perfectly.

Thank you Guys.

[rubenmarin1]

Nice, glad to help.

[#5]

Hi All.

Thank you all i got the answer and its working Properly

[#6]

Hi,

In dimension , You can try this condition .

=if(Len(Service)>0, Service)

[simenkg]

How about just using Service as dimension and using the expression:

sum({<Service={"=Rank(Sum(People))<=vTopValue"}>} People)