Hello, I want to develop a sheet that reccomends to move a item from one store to another, based on less days that the item is excpected to be on stock.
I have a table that shows thoese values:
Store name,
Item code,
Sales amount,
Inventory amount,
Inventory entry date,
sales amount / inventory amount * today()-[inventory entry date] AS [stock expected days]
| store |
item code |
sales amount |
inventory amount |
inventory entry date |
stock expected days |
| STORE A |
8574 |
15 |
1 |
01/09/2022 |
0.47 |
| STORE B |
8574 |
17 |
3 |
25/07/2022 |
7.94 |
| STORE C |
5874 |
21 |
1 |
15/06/2022 |
4.05 |
I want to be able to get a table like this:
SELECTION: CURRENT STORE - STORE B
| item code |
current store |
current stock days |
target store |
stock expected days |
| 8574 |
STORE B |
7.94 |
STROE A |
0.47 |
Can you advice? 😅
