calculate how many new clients

[chriscools]

Hello,

i want to count the number of new customers that were created.

the amount of orders they place i can derive like this:

sum (if ( WholesaleCustomerCode > [vNieuwe klantennummers] , ( OrderPriceUnitNet * OrderQty)))

where [vNieuwe klantennummers] equals the last created customer i don't want to calculate as new.

this works fine but i also want to calculate the number of new customers and i try to do it like this, but this gives me no result.

is the expression wrong?

if ( WholesaleCustomerCode > [vNieuwe klantennummers] , Count (DISTINCT WholesaleCustomerCode ) )

thanx!

chris

[m_woolf]

Why not try the same syntax you are using for Order Amount?

count(distinct if ( WholesaleCustomerCode > [vNieuwe klantennummers] ,WholesaleCustomerCode ))