Cumulative sum not working correctly?

[HugoTorres]

I have a running calculation for a count distinct on a number of items created per month. If I understood this correctly, this should calculate the count distinct for each month and when the running sum is added, it should add the values there were previously, so the difference between two months, should be the count distinct of items created in that month. However, this is not what is happening. Am I misinterpreting the way this works? 

[sam8]

How did you set up the calculation? I'm curious how you made a running count distinct. 

I would start with a count distinct for each month and then make a running sum table calculation on top of that. I think that would give what you're expecting!

[HugoTorres]

Hello  @sam8 . I am pretty sure that's what I did and still got values different than expected. I need to check this again because it has been a while since I have faced this issue, but I am pretty sure that what I did was setting up the calculation as a count distinct and then setting up the running calculation as a cumulative sum. I will test this again and we can discuss it further