Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
Hopefully you can help. I'm trying to get a distinct customer count where the sales are > 0.
Here's my set analysis
Count(Distinct{<Sales = {">0"}> } CustomerNumber)
Thanks,
Alex
I hope this should work !!
Count({<CustomerNumber= {"=Sum(Sales)>0"}> }Distinct CustomerNumber)
Ok Thank You,
I'll try it.
Thanks for the feedback
I'll check it out