Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
Try: NumericCount((DISTINCT {<OrganisationID={"=Sum(Sales)>0"} ,PeriodYear = {$(vCurrentYear)}>} OrganisationID)
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?
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?