Count If In Dimension Expression

[dmac1971]

I want to show a list box showing only customers who have open sales lines, my expression is :

If(Count (Total Order_Number)>0,Customer)

However this wont work, any pointers?

[Chanty4u]

If(Count (only(Total Order_Number)>0,Customer))

[dmac1971]

Sorry doesn't work, empty table.

[marcus_sommer · Accepted solution]

You need to wrap your condition within an aggr-function: aggr(count(Order_Number)>0, Customer)

- Marcus

[dmac1971]

That sorted it Marcus, many thanks :

if( aggr(count(Order_Number), Customer)>0,Customer)