Hi Everyone! I need your help.

Let me describe it from the beginning:

I need to count for how many days specified Material was in stock.

ToDo this I have 2 SAP tables:

1 Is the (MARDH) Amount of Material on the 1st of the month

Date,
Material,
BussinessUnit,
Warehouse,
MonthStartAmount

2 Is the (MSEG+MKPF) Is the moves of this material

Date,
Material,
BussinessUnit,
Warehouse,
Move

//Moves are already + and - so i can sum() group them by Date.

So I can make a chart and see the amount but only for the dates that were assosiated with material.

Looks like i need an expression to show me the amount of material for every day, so that i can count "0" later.

Should have asked you earlier.

I've been thinking about this for a week already, please help.

Thanks, Maxim.