Forum Discussion
Helper IIIDischarge department
Community Championbdeleur
For now this is what I can provide you. The difference between Count 2 and Count 3 is that count 3 shall not count discharged from same department unless there is a discharge date. The difference shall not be noticed using the sample data as there are no blanks in the end date.
Helper IIIHi tamerj1 ,
Sorry for the delay. It was a bussy week.
The count seams to work.
I have a question still: the totals give a differnt count the the sum in the matrix.
And I want to skip the count the movement between the same department, it isn't relevant.
Can you help me to understand it?
- tamerj1
HI bdeleur
I can understand when the total counts less. That is expected. If the same reference extends over the two months then it will be counted in both months while at the total level it will be counted once. Therefore, this is a non-additive calculation by nature like distinctcount. However, it is up to your business logic to determine whether to force additivty or not.
Don't be confused about the scenarios where the total counts more. Notice that this only happens when Feb returns blank value. Which means that some references were neither counted in Feb. nor in Mar. Apparently one record in Feb. and one record on Mar. so it will be counted in neither but the in the total level.To exclude same department movements just return to the very first solution.
- bdeleur
Tnx for the answer. When I use my calander the count is correct, so I will use that.
Tnx for all your help, coudn't done it whitout you and I learned a lot.
I will accept your help as the solution.