Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Trie with this.
hope it helps you.
regards.
=num(
count( {$<OrderValue <> {'0'}>} Customer ) /
count( {$<OrderValue = >} Customer ),'#,00%')
I'm sorry but it doesn't work
Thanks
can you add me a qvw sample?
regards,
Unfortunatly I can't