Set Analysis in If expression

[#1]

Hi guys,

I have this expression

count(distinct {$<id = P({1<bonus={"*"}>})>} id)

and i want to use it in a dimension like this

If (count(distinct {$<id = E({1<bonus={"*"}>})>} id) <> 0, Number)

But it does not work and gives error "Error in calculated dimension".

What I want to do is....if count is not equal to 0 then only show a particular "Number " on the dimension...

Any help would be appreciated.

Regards,

Saurabh

[mambi]

Why you don't just use : if (count( {1} distinct bonus)>0, Number)

[#3]

Hello,

may you attach application with sample data?

regards

Darek

[#4]

It still gives same error

[swuehl · Accepted solution]

Try

=aggr( If (count(distinct {$<id = E({1<bonus={"*"}>})>} id) <> 0, Number), Number)