Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Sum Over Interval in Two Columns

Hi there!    I have a database that show me some ongoing and scheduled processes, how many goods are being used, start month and end month of every process. Most of them take about 3 months to comp...
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Anonymous 

So, what does the result you want to achieve look like ? Could you describe the result you want through formulas or specific data , maybe this will help us solve the problem better.

 

Best Regards,
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Anonymous ,

 

This is the real database below. The third column is the quantitites I need to sum. The #5 is the starting month and #6 is the end month. 

 

I have this table that shows me, per month, the sum of everything coming back and everything leaving my warehouse. Now I would like to add a third column with Total Out of Stock. So, if a material is taken in May-2022 and is returned in July-2022, it should be summed in May, June and July (where I marked the X below).

And I have no clue of how to create this measure. The interval is defined by those 2 columns above. 

Thanks!