Count by Month - set analysis

[bellesol]

Hi,

I have been asked to build a table by month and year that shows the number of open items in a storage.

I want to build a table that would not be affected by the user's selections, the table will display by month and year the amount of items in the storage , for example in February , the relevant data will be all the items that the enter date is less than 28.02.2020, i.e., all the items that enter in January and February 2020.

a table with a dummy data:

*I also attached the excel file*

For example:

Item that has entered on 15.1.2020 and was out on 21.02.2020, In the "Final column" I need to count this item only one time in  the January month row ,this item will not be calculate on  February because the date out is less the 28.2.2020 .

How can I Build the expression in the "Final column"?

I tried something like this expression:

=count({<[Enter Date]={"=Monthend([Enter Date],0)<=[Date OUT]"}>} [MRB])

[bellesol]

Hi,

Can someone help? 

[sunsun566]

Hi 

I think you can expand each Item to every day, the formula coding will be much easier.

Hope it helps you:)

[agigliotti]

Hi @bellesol ,

Could you post a sample app with mock data to look at?