Help with set analysis

[Anonymous]

Dear all,

I've to calculate how many customers have sales order value <> 0 in percentage , matching this value with the total customer number

Total customers:                                        10000

Total customers with sales order amount:     2000          PErc.  20%

I've prepared one table where I joined customers and orders and I'm trying without success the following:

count({<{"=Sum(OrderValue) <> 0"}>} distinct Customer )

but it doesn't work

What can I do ? Help please !!

Thanks in advance

[fdelacal]

Trie with this.

hope it helps you.

regards.

=num(

count( {$<OrderValue <> {'0'}>} Customer ) /

count( {$<OrderValue = >} Customer ),'#,00%')

[Anonymous]

I'm sorry but it doesn't work

Thanks

[fdelacal]

can you add me a qvw sample?

regards,

[Anonymous]

Unfortunatly I can't