Forum Discussion
Rolling Sum Not Working when Empty Data
Hope this video helps:
Thank you, but the same outcome as previous two methods. My best guess is that there is either a problem with my date hierarchy, or that it is having a challenge handling data with no records (There is no January records of this dataset, so when i select january for R2M, it shows null)
In your case, the total is calculated based only on the current value and the immediately preceding value.So in Feb 22, it is adding The value of Feb 22 and Jan 22, which are both 0 and therefore you get 0 as the result
Hi Pady, i show in my example above. I am trying to pull Jan 2023 rolling 2 months inventory.
December 2022 had 9 units
January 2023 has 0 units
R2M result should be 9. I have now solved my challenge, somehow my date table had duplicates so the relationship created was incorrectly created as Many to Many. Solved by removing duplicates and changing to Many to One