Forum Discussion
Instock Instance last 14 days
I want to calculate instock instance for each material number and plant for last 14 calendar date. Please let me know what query should I use. Thanks
smpa01
Community Champion
Community ChampionCan you please provide sample data and elaborate on the calculation logic behind instock instance
Please see the attached image for sample data. Instock Instance is calculated by count effective calendar date where OOS_IND= Instock . Also, I think it wont affect anything just consider instock instance as sales or any other qty. So basically can you please provide me query to calculate that field for last 14 calendar date ?
