Flop 5 with NULL values

[CSchoene]

Hello,

I wanted to create a table with the flop 5 customer.
They all have a turnover but some of them turnover has got null values as their turnover. Surely the flop 5 Customers are the ones without a value but I want to generate a table without these null values.

Now the problem is that I can´t restrict the turnover >0 and generate the flop 5 customer at the same time.

Has someone an idea to solve these problem?

Thank you

Christina

[Channa]

try to make preceding load 

load * where value>0