Expression with NumericCount and Sum

[Anonymous]

Could someone help me with this expression? As long as I keep the sum out of the expression it works fine, but the expression needs to have a sum of the Sales to exclude customers that due to a correction have a minus sales value that's equal to de plus sales value.

NumericCount

(DISTINCT{<Sum(Sales) = {">0"} ,PeriodYear = {$(vCurrentYear)}>} OrganisationID)

[Gysbert_Wassenaar]

Try: NumericCount((DISTINCT {<OrganisationID={"=Sum(Sales)>0"} ,PeriodYear = {$(vCurrentYear)}>} OrganisationID)

[Anonymous]

Thank you for your answer. It comes close but it isn't the solution. My original expression depends in all cases on currentyear. When I try your solution the numbers change when I select another year. Any idea?

[Anonymous]

I have made a sample qvw. The part above is about the sales and the under the sales part there is information about the number of employes that have worked at a certain esthablishment and the total hours that the employes have worked.

The problem is that when I select the brand Skoda or Seat in the pie-chart the total worked hours change.

How can I ensure that the total worked hours don't respond on the car brand that I select?