Forum Discussion
rolling inventory level over time
Hi dannecr ,
Is there a calendar table in the model? Or a column for sorting [goods out - date]? What is [goods out - date]s data type?
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data
Hi Gao,
thanks for your message.
So far there is not a calendar table included in the model; also a column for sorting [goods out - date] is not yet implemented.
The [goods out - date] column is originally a date type but was converted to a text type. E.g. "15/12/2022" is converted to "Dez 22" --> Date.ToText([goods out - date], "MMM.yyyy"))
The input table has only the 3 columns as shown in the example.
[Article] [goods out - date] [goods out - quantity]
All [goods out - date] values are in the future.
I wanna show the current stock level based on [goods out - quantity].
And once- goods are shipped out I want to display the new stock level.
Thanks 🙂