Forum Discussion
Number of days with quantity greater than 0
Hi,
I am working on a function that consists of a table with entries on items, the changes in stock and new stock. I want to count every day, where the minimum of Inventory was greater than zero per Artice-No.
My problem is that, there is more than one entry per day, so I would first have to determine the minimum per day.
In addition, not every item has one entry per day and sometimes the Inventory is negative.
My table looks like this.
| Article-No. | Old inventory | Inventory changes | New inventory | Date |
| 1 | 20 | -5 | 15 | 01.01.19 |
| 2 | 5 | -3 | 2 | 01.01.19 |
| 1 | 15 | -3 | 12 | 01.01.19 |
| 1 | 12 | -2 | 10 | 01.01.19 |
| 1 | 10 | -5 | 5 | 31.10.19 |
| 1 | 5 | -5 | 0 | 31.10.19 |
| 2 | 2 | -5 | -3 | 01.11.19 |
And so on.
Many Thanks in advance.
1 Reply
Yonah_ Have not considered a formula solution as this can fairly easily be resolved with Power Query. A working example is in the attached workbook.
