calculation of a value in a column depending on the sum of older entries

[kavieweg]

Hi together,

I would like to have an Diagramm where I can see the packing date and packing time on the x Axis and the "total weight so far" on the y axis.

I do not have re results of the column "total weight so far" and have to calucalte them. The value the "total weight so far" is always the sum of the order weight where the "packing time" is less than the current packing time of the packing date.

Order	packing date	packing time	order weight	total weight so far
A	01.03.2018	07:00	5	0
B	01.03.2018	07:50	9	5
C	01.03.2018	08:10	12	17
D	01.03.2018	12:30	6	23
E	01.03.2018	14:00	8	31
F	01.03.2018	15:00	9	40
G	02.03.2018	06:00	10	0
H	02.03.2018	07:50	11	10
I	02.03.2018	08:30	67	21
J	02.03.2018	11:00	9	88
K	02.03.2018	14:00	8	97

Thanks for help.

Mathias

[wdchristensen]

Interval(Now(1)-Packing_DtTm, 'D hh:mm') 

[kavieweg]

Hi William, I am still checking the results and come back by end of this week. Thank you for all your help. I will mark the right answer when i checked the resuts.

Best regards from Munich