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
