Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try
=aggr( If (count(distinct {$<id = E({1<bonus={"*"}>})>} id) <> 0, Number), Number)
Why you don't just use : if (count( {1} distinct bonus)>0, Number)
Hello,
may you attach application with sample data?
regards
Darek
It still gives same error
Try
=aggr( If (count(distinct {$<id = E({1<bonus={"*"}>})>} id) <> 0, Number), Number)